Combining Worksheets Formula

  • Thread starter Thread starter Tami
  • Start date Start date
T

Tami

Good Morning,
I have a file that has approx. 500 different sheets in
it. Is there anyway I can write a formula, macro, etc.,
that will combine all of the spreadsheets into one file
as opposed to copy/pasting each one? They are all in the
same format.
Any help would be greatly appreciated. I will be here
for the next month trying to copy all 500 sheets into one.

Thanks much,
Tami
 
Hi Tami

haven't tried it with that many worksheets but have you had a look at
Consolidation on the Data menu - it might be what you are looking for.

Cheers
JulieD
 
Back
Top