How do I combine multiple worksheets into one worksheet?

G

Guest

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

How do I combine worksheets 2
how do I combine multiple worksheets into one? not summarize 1
Combine several spreadsheets with multiple worksheets into 1 file 5
combine columns of data from multiple worksheets into one 7
Linking worksheets 1
Linking Multiple Worksheets and Cells 1
How do I combine worksheets w/o enough rows to combine? 3
HOW CAN I COMBINE SUBTOTALS? 1

Top