| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare and import data using two spreadsheets | Excel Discussion (Misc queries) | |||
| Possible to import data from spreadsheets on sharepoint site? | Excel Discussion (Misc queries) | |||
| Enter data to one spreadsheet, have other spreadsheets take that d | Excel Discussion (Misc queries) | |||
| How to move data from spreadsheets to spreadsheet? | Excel Discussion (Misc queries) | |||
| Import data to a spreadsheet. | Excel Discussion (Misc queries) | |||
Linear Mode
