Combining Multiple Sheets into a single sheet

  • Thread starter Thread starter Steve Welman
  • Start date Start date
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
 
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
 
Back
Top