Importing multiple worksheets

  • Thread starter Thread starter denilynn
  • Start date Start date
D

denilynn

Is it possible to import multiple worksheets into another
Excel workbook or Access database?

Thanks much!
Denilynn
 
You'll have to open all of the workbooks in question, select the sheets to be copied or moved,
then go to the Edit menu and select Move or Copy Sheet. The other option would be to accomplish
the same thing with a macro. It would do exactly the same thing: open the "other" workbook and
copy the sheets to the first workbook. Unless you have to do this a lot, a macro is probably
overkill.
 

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

How do I import data from a text file into Excel 2003 2
multiple workbooks in one file 3
auto update to multiple worksheets 2
Linking multiple worksheets in one workbook 2
Import Data from the Same Workbook 1
Import Multiple CSV Files from Same Folder into Open Workbook 5
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
automatically import multiple named-ranges from Excel to Access 1

Back
Top