Hi everyone,
I have a master workbook (named "consolidated") where I need to run a macro that:
- opens one after the other 8 workbooks of a folder selected by the user
- copy data from each workbook to a corresponding sheet in the master workbook
For example:
Open 1st workbook of the folder and copy data of activate sheet to sheet8 of the master book
Open 2nd workbook of the folder and copy data of activate sheet to sheet9 of the master book
etc... until 8th workbook and sheet16
For that purpose, I am using a code with "Do / Loop" to open the files of selected folder and "For i = 9 to 16 / Next i" to copy data and move to the next worksheet.
My problem is that I cannot combine these 2 loops, they only run one after the other.
Can anyone help me with my code?
Thanks in advance
Figolu
Bookmarks