Combining data from multiple Excel Files

[robbyvegas]

Here is the question...

I have select data entries (I need the same information from each spreadsheet) in multiple (=52*7) excel spreadsheets (separate files) that I need to collect into 1 spreadsheet. The format of the source table is almost always the same, and the title row of the column that I need to retrieve data from IS ALWAYS the same. Is there a way to save myself some time here, or am I destined to spend the next few hours in copy-paste world?

Thanks,
Rob

[pike]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.