Combining Worksheets Formula

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
 
J

JulieD

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
 

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

Combining two sheets of data into one and sorting by value - using macros 5
External cell reference between two excel worksheets both in One Drive 0
How To Rapidly Copy Formulas? 0
Needs help combining functions. 3
Using countif with multiple criteria 0
Combining Multilple Worksheets Into One 6
How to I combine excel worksheets? 5
Simple Consolidation of Worksheets 2

Top