Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default Importing worksheets into another workbook.

Is there a way to copy or inport a worksheet from one workbook to another
while saving the format.

Thanks
--
Rose
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Importing worksheets into another workbook.

Edit/ Move or copy sheet.
--
David Biddulph

"Rose" wrote in message
...
Is there a way to copy or inport a worksheet from one workbook to another
while saving the format.

Thanks
--
Rose



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default Importing worksheets into another workbook.

Hi David,

The Copy and Move Sheet is not working. It will only create a new sheet in
the existing workbook or a new workbook. How do I get it to copy one
worksheet into another already existing workbook?
--
Rose


"David Biddulph" wrote:

Edit/ Move or copy sheet.
--
David Biddulph

"Rose" wrote in message
...
Is there a way to copy or inport a worksheet from one workbook to another
while saving the format.

Thanks
--
Rose




  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,651
Default Importing worksheets into another workbook.

Open the other book, then you can move or copy to it.
--
David Biddulph

"Rose" wrote in message
...
Hi David,

The Copy and Move Sheet is not working. It will only create a new sheet
in
the existing workbook or a new workbook. How do I get it to copy one
worksheet into another already existing workbook?
--
Rose


"David Biddulph" wrote:

Edit/ Move or copy sheet.


"Rose" wrote in message
...
Is there a way to copy or inport a worksheet from one workbook to
another
while saving the format.

Thanks
--
Rose






  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Importing worksheets into another workbook.

Make sure you open the workbook that's going to receive the copied worksheet.

Rose wrote:

Hi David,

The Copy and Move Sheet is not working. It will only create a new sheet in
the existing workbook or a new workbook. How do I get it to copy one
worksheet into another already existing workbook?
--
Rose

"David Biddulph" wrote:

Edit/ Move or copy sheet.
--
David Biddulph

"Rose" wrote in message
...
Is there a way to copy or inport a worksheet from one workbook to another
while saving the format.

Thanks
--
Rose





--

Dave Peterson
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
Importing from one workbook to another Bill Barber Excel Worksheet Functions 2 May 8th 06 08:08 PM
Importing From one Workbook to Another Bill Barber Excel Worksheet Functions 0 May 6th 06 02:10 AM
Help! importing data from other worksheets... Pete Excel Worksheet Functions 0 May 4th 06 12:06 PM
Importing XML files into individual worksheets PabloB Excel Discussion (Misc queries) 0 April 24th 06 06:12 PM
Importing Data from unopened Workbook into an open Workbook GrayesGhost Excel Discussion (Misc queries) 0 March 5th 05 11:25 PM


All times are GMT +1. The time now is 03:09 PM.

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

About Us

"It's about Microsoft Excel"