ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How 2 import Excel file w/ multiple worksheets ??? (https://www.excelbanter.com/excel-discussion-misc-queries/244323-how-2-import-excel-file-w-multiple-worksheets.html)

akm

How 2 import Excel file w/ multiple worksheets ???
 
How to import an Excel file into another Excel file, both with multiple
wkshts ?

Or do need to copy one wksht at a time from one to other ?

--
Thanks again for your help.
akm (XPpro,SP-2,IE-7,Office2003)


Sean Timmons

How 2 import Excel file w/ multiple worksheets ???
 
Click on first desired tab.

If moving non-adjacent sheets, hold down the ctrl key and click the other
desired tabs.

If adjacent, hold the shift key and click the last tab.

Right-click on one of these tabs and click Move or copy.

Select your destination workbook in the drop-down and choose between move or
create a copy using the checkbox.

"akm" wrote:

How to import an Excel file into another Excel file, both with multiple
wkshts ?

Or do need to copy one wksht at a time from one to other ?

--
Thanks again for your help.
akm (XPpro,SP-2,IE-7,Office2003)



All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com