Convert multiple workbooks to different worksheets in 1 workbook

  • Thread starter Thread starter kalimai
  • Start date Start date
K

kalimai

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Merge Multiple workbook sheets into one workbook 0
consolidate workbooks to worksheets in one workbook? 1
Editing Data in Multiple Worksheets/Workbooks 1
Multiple Worksheets 6
formula between two workbooks 1
replace all formulas with values in multiple worksheets 5
Print selected worksheets in multiple workbooks? 1
Data aggregation with multiple workbooks 1

Back
Top