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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF, 3D FORMULA, EXCEL FORMULA HELP 1
Simple Consolidation of Worksheets 2
How to I combine excel worksheets? 6
Collapsing all groups 0
How do I combine worksheets 2
vlookup with multiple values 3
Combining data 1
How do I combine lists in multiple worksheets 1

Back
Top