import data from several spreadsheets into one spreadsheet

  • Thread starter Thread starter RELIANCE
  • Start date Start date
R

RELIANCE

How do I consolidate several spreadsheets into one spreadsheet with each
spreadsheet on a different tab in the new spreadsheet? How do I do this with
the least keystrokes?
 
You have several Excel Workbooks that you wish to combine into one Excel
Workbook............right?

How many Worksheets does each Workbook have?

Or does each Workbook contain only one Worksheet?

You can copy a Worksheet from one Workbook to another but you cannot copy an
entire Workbook to a Worksheet in another Workbook.

Please clarify your needs.


Gord Dibben MS Excel MVP
 
Back
Top