MagicalHippo
Board Regular
- Joined
- Oct 13, 2015
- Messages
- 122
I am a bit confused on how to attempt this as my array knowledge is somewhat limited. Initially, I thought about creating a loop to loop through workbooks and copy the ranges....but realized the copied ranges need to be dumped into their own sheets.
How would I open multiple workbooks, run the same code on all of them, and copy range to lastrow and put it into an array? (i.e. Open WB1, copy range into array, open WB2, copy range into an array. Then paste WB1 to Sheet1, and WB2 to sheet2 etc.)
Thanks
How would I open multiple workbooks, run the same code on all of them, and copy range to lastrow and put it into an array? (i.e. Open WB1, copy range into array, open WB2, copy range into an array. Then paste WB1 to Sheet1, and WB2 to sheet2 etc.)
Thanks