Pull a single table from multiple .xls files

[BigBlueScreen]

Hi All,

I need to take a single table that exist in each of the .xls files and combine them into a single file.

The twist to this is that the table can span multiple tabs.. It always starts on tab 2 beginning with the header "machine parts" (data on line 6) and ends with the header "machine".

Let me know if any other info is needed.

Any help greatly appreciated.

JD

 

[MacroAlan]

Have you tried iterating thru each worksheet; something like

For X = 2 to Worksheet.count

Sure, you have to perform the find and move each time.


Alan