| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
consolidate workbooks to worksheets in one workbook?
I have a folder which contains workbooks, each with only one sheet of data. I
wish to consolidate the data from each workbook into a single workbook with multiple worksheets. I would also like each new worksheet to have the name of the workbook it came from. Can anyone help? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
consolidate workbooks to worksheets in one workbook?
Hi,
See Ron web http://www.rondebruin.nl/summary2.htm http://www.rondebruin.nl/copy3.htm if this helps please click yes, thanlks "Neil" wrote: I have a folder which contains workbooks, each with only one sheet of data. I wish to consolidate the data from each workbook into a single workbook with multiple worksheets. I would also like each new worksheet to have the name of the workbook it came from. Can anyone help? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Detach different WORKSHEETS in one WORKBOOK into DIFFERENT WORKBOOKS | Excel Worksheet Functions | |||
| Macro To consolidate All Open Workbooks Into One Workbook | Excel Worksheet Functions | |||
| 2 Workbooks and 6 Worksheets - Need to Populate 1 Workbook | Excel Worksheet Functions | |||
| Consolidate multiple worksheets in a workbook into one | Excel Discussion (Misc queries) | |||
| Copying Several Workbooks into one Workbook as Worksheets | New Users to Excel | |||
Linear Mode
