consoildate all the worksheet(example sheet1,sheet2 and sheet3 etc

O

officeboy

need help

i have a lot of worksheet(sheet1 - sheet50... etc)in a single spreedsheet.
Is there any fomula to consoildate/combine all the 50worksheet into 1 single
spreedsheet?
Example in each worksheet i have 10 entries
So 50 worksheet i will have 500 entries. Is there any way that I can
consoildate all the 500 entries into 1 particular worksheet? Beside cut&paste
and pivot table. Is there any function?
 

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

Scrubbing two excel worksheets, returning unique values from one sheet 0
sum from many worksheets 2
Code to format cells on several worksheets 2
= Today()+1 into Sheet1, Sheet2, and Sheet3 2
matching values between worksheets 8
Excel Challenge: Copy and pasting sheet1 to sheet2 3
Making data in appear in one worksheet from another 2
Combining data from two columns into one - appending new values tothe end of one column 4

Top