Hello all,
I am looking for a solution for the following problem: I want to automatically merge data from several action lists into one big action list.
In "C:\directory 1" the file is located where I want to combined all the data, this file is called "Merged data.xlsm", this workbook has a sheet called "Sheet 1". The data should be copied to the cells B2:I???, and the data from the next action list should be pasted beneath this data.
The separate actions lists are located in multiple subdirectories with different names in "C:\directory 1", and all those files also have different names. All these workbooks are .xlsm files and they all have a worksheet called "Action List". The data in these sheets is located in B17:I???.
I want to make a macro in the workbook "Merged data.xlsm" that automatically merges the actions into one big action list.
I hope you guys and gals can help me.
Kind regards,
RvEPE
I am looking for a solution for the following problem: I want to automatically merge data from several action lists into one big action list.
In "C:\directory 1" the file is located where I want to combined all the data, this file is called "Merged data.xlsm", this workbook has a sheet called "Sheet 1". The data should be copied to the cells B2:I???, and the data from the next action list should be pasted beneath this data.
The separate actions lists are located in multiple subdirectories with different names in "C:\directory 1", and all those files also have different names. All these workbooks are .xlsm files and they all have a worksheet called "Action List". The data in these sheets is located in B17:I???.
I want to make a macro in the workbook "Merged data.xlsm" that automatically merges the actions into one big action list.
I hope you guys and gals can help me.
Kind regards,
RvEPE
