This project would be to create a database structure/schema based on a given set of data.
I have a file that gets saved down nightly. I am looking to create a user interface such that I can \\\"slice and dice\\\" the data to create reports on the fly. I can do most of the reporting myself, I just need help writing the VBA to automate importing the .csv file, fill blank fields with \\\"NA\\\" and then need help organizing the data into logical tables and normalizing the structure.
Hi! I am very interested in your project. I can do it entirely in excel using the Power Query and Data Model so you would have all in one file and can generate reports. Please contact me in chat for futher details.