import data from several spreadsheets into one spreadsheet
 

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?

import data from several spreadsheets into one spreadsheet
 

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

On Thu, 14 Jan 2010 13:01:02 -0800, RELIANCE
wrote:

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?

import data from several spreadsheets into one spreadsheet
 

Hi,

You may refer to this article

http://datapigtechnologies.com/blog/...iles-method-2/

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"RELIANCE" wrote in message
...
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?