Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert multiple workbooks to different worksheets in 1 workbook
I have several excel workbooks, each with only one sheet used. Is it
possible to convert these all at once to one workbook with multiple sheets (one sheet for each orginal workbook)? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert multiple workbooks to different worksheets in 1 workbook
Hi
Open a workbook where you want to collect tables (target); Open one of workbooks with table to export (source); Right-click on tab where the table is located, and select from drop-down menu 'Move or Copy ..."; In 'To book' field, select the target workbook; Optionally you can check 'Create a copy' (to peserve table in source workbook too, otherwise the sheet will be moved). And you can determine the location, to where the sheet will be inserted in target workbook; Press OK; Close this source workbook (optionally saving it), and open the next one; Repeat the cycle until all tables are copied/moved; When copied sheets had same names in all source workbooks, then you have to rename new sheets in target workbook. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "kalimai" wrote in message ... I have several excel workbooks, each with only one sheet used. Is it possible to convert these all at once to one workbook with multiple sheets (one sheet for each orginal workbook)? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Convert multiple workbooks to different worksheets in 1 workbook
Hi kalimai
See http://www.rondebruin.nl/fso.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "kalimai" wrote in message ... I have several excel workbooks, each with only one sheet used. Is it possible to convert these all at once to one workbook with multiple sheets (one sheet for each orginal workbook)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
Convert 2 workbooks into 1 workbook | Excel Discussion (Misc queries) | |||
Convert excel worksheets into new workbooks (new files) | Setting up and Configuration of Excel | |||
adding certain cells in multiple worksheets in multiple workbooks | Excel Worksheet Functions |