Sorry about asking such a complex question for my first post but here goes.
I have a folder with about 1000 files, each of these files are identical in format, with 5 worksheets with one being hidden called RawData.
In another folder I have a file called MasterFile which has 10 worksheets with one called RawData.
The problem, I have to open each file in the first folder and copy the contents of the worksheet called RawData, into the MasterFile spreadsheet, I then have to save the MasterFile based on the cell value in cell C3. The newly created file need to be saved in a seperate directory to the original files.
Could someone please help me to set up a macro to automate this process as I suspect it will take me along time manually?
I have a folder with about 1000 files, each of these files are identical in format, with 5 worksheets with one being hidden called RawData.
In another folder I have a file called MasterFile which has 10 worksheets with one called RawData.
The problem, I have to open each file in the first folder and copy the contents of the worksheet called RawData, into the MasterFile spreadsheet, I then have to save the MasterFile based on the cell value in cell C3. The newly created file need to be saved in a seperate directory to the original files.
Could someone please help me to set up a macro to automate this process as I suspect it will take me along time manually?