Hi Experts (excel 2010)
I need a macro to open up all workbook stored in folder “this period” one by one and copy the data in the range A3: AB3, based on the last cell in column A (i.e. dynamically) find the last value in column A – starting at A4 and then copy the data in the above range from the first workbook and paste the data into the open workbook called “datamart” into worksheet called “change control” data range A3:AB3.
One this has been completed, closed the workbook, from folder “this period”, then
Open up the second workbook, and repeat the above steps, “trick” here is to find where the last data was pasted into the “datamart” worksheet and append the data to the previous copied data from the first workbook. Close workbook once completed
Repeat steps above until all workbook in the folder “this period” have been opened and copied into the master workbook “datamart”
So in a nutshell we are open each workbook one by one stored in folder “this period” and appending the data to the workbook “master”, worksheet “datamart”.