How do I combine multiple worksheets into one worksheet?

L

Lianne

I have a woorkbook with multiple sheets (100+) which I need to analyse. I
need to combine all the worksheet data into one worksheet to be able to
manipulate.
All worksheets have the same table format but all contain different numbers
of rows. I will receive a different report each month from which I need all
the worksheets combined but each time there may be a different number of
worksheets and a different number of rows.
Is there a way to combine these into one 'lump' of data??
Thanks
 

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

Embed the same Excel multiple times 0
Possible to Combine reports to's to a single box? 0
Syncing between source worksheet and dependent worksheets 0
Tracked changes by multiple people modified to one 0
Combine several spreadsheets with multiple worksheets into 1 file 5
Combining Multilple Worksheets Into One 6
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
need help on either doing a loop and counting specific values orusing subtotal function 2

Top