Combining Multiple Sheets into a single sheet

S

Steve Welman

Hi

I have 6 spreadsheets, each with in excess of about 80 sheets and would like
to combine all the info from all the sheets from a single spreadsheet into
1 single worksheet within the same spreadsheet.

Can someone please tell me how to do this. Additionally, all the
information on every sheet is similiar, except that every sheet contains a
different number of rows of data.

Thanks in advance
 
T

Tushar Mehta

Depending on what you mean by "combining," XL's PivotTable's
Consolidation capability may be what you are looking for. Start with
Data | PivotTable and PivotCharts... (*) | select consolidate multiple
ranges in the first step of the resulting wizard.

(*) The menu item name varies by XL version.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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

More Rows/One Sheet vs More Sheets/Less Rows for best performance? 1
Combining multiple files into one work sheet 4
Copy Data from One sheet to Different Sheets 1
Multiple sheets printed to single page 1
Formula to consolidate 130 sheets into a summary sheet 6
Macro executing (copy data) from at sett of sheets in the workbook 3
Identifying Duplicates in Multiple Sheets 4
Excel2007 | I want to create a pivotTable from a different data, and different sheets 0

Top