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)?

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)?

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)?