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.
 
Back
Top