View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default 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)