Hi All,
Firstly thanks for help in advance, people in this forum are fantastic
My issue is as follows:
I'm trying to copy data into an array from various workbooks and then put said data into another set workbook. My source workbook has 3 SET worksheets which do not vary meaning getting data from these is perfectly fine and I've accomplished this task.
However, AFTER these sheets there are other sheets with info I need on however they're always named differently in each workbook. This can range to 1 extra sheet or 10 extra sheets.
An example would be that my Source workbooks may have sheets called:
A, B, C Then 54, 59
A, B, C Then 99, 101
A, B, C then 12, 84, 59, 78
etc
I can take any info from sheets A,B,C on any workbook however Its navigating to the data on the dynamic worksheets I have issues with.
The only solution I can think of is that on those dynamic worksheets, there is ALWAYS the same Headers so perhaps I can do something along the lines of:
If not named A,B,C
Then check for the set Header I need.
If found then copy everything BELOW that header into an array
Next check (To see if there is another sheet)
If yes then copy into same array
If Not stop check.
Any ideas?
Thanks In advance, this ones a toughy!!
Bookmarks