Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
akm akm is offline
external usenet poster
 
Posts: 19
Default 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)

  #2   Report Post  
Posted to microsoft.public.excel.misc
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)

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Split a worksheet into multiple worksheets of the same Excel file shree Excel Discussion (Misc queries) 1 November 4th 08 08:24 PM
Can I create a chart from multiple worksheets in the same Excel file? Link New Users to Excel 2 April 11th 07 05:43 PM
how can i import worksheets from multiple workbooks davidp23 New Users to Excel 1 September 1st 06 08:49 PM
Amalgamate Several Worksheets into one file thru Data import M Imran Buhary Links and Linking in Excel 1 May 29th 06 11:08 AM
Amalgamate Several Worksheets into one file thru Data import M Imran Buhary Excel Discussion (Misc queries) 0 May 28th 06 11:29 AM


All times are GMT +1. The time now is 05:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"