Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pulling table from multiple xls files

Status
Not open for further replies.
BigBlueScreen

BigBlueScreen

Technical User
Jul 23, 2004
31
US
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
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
multiple err handling
Replies
6
Views
311
remeng
remeng
feipezi
  • Locked
  • Question
How to find a string from multiple Word files, which are listed on an Excel spreadsheet? 3
Replies
17
Views
387
Andrzejek
Andrzejek
remeng
  • Locked
  • Question
CTRL + BREAK from second macro button
Replies
5
Views
356
strongm
strongm
remeng
  • Locked
  • Question
Delete dynamic table rows without removing password protection
Replies
7
Views
255
remeng
remeng
remeng
  • Locked
  • Question
Getting results from a dynamic dimension array
Replies
2
Views
284
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top