This is Phase 2 of project. I have some raw files that are automatically generated and dropped into a single folder every day.
I also have some master files which are similar to the raw files but they contain the combined data of the raw files, i.e raw file day 1 + raw file day 2 + raw file day 3 + ... + raw file day n = master file. Some master files have additional calculated columns with formulas based only the raw data.
Currently every day I open the raw files and copy the data from the raw files and paste them to the master files. For those master files that have additional calculated columns, after I paste the data from the raw file to the master file, I then copied those calculated columns down.
I need a script that can perform the above steps for me automatically every day at a set time.
6 freelancers are bidding on average $144 for this job
Hello, I would like to work on your project. I have great experience using excel, data manipulation in excel, working with multiple files with transferring data with / without changing data format.
Hi, I am interested to develop vba script in order to read from many raw files in to a master file after click on a button or any other even. Please consider my bid and experience. Regards Prakash