Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 12
Default Move and Copy

Working with Excel 2003 - I am trying to place a previous work spreadsheet
into another workbook - however, when I attempted to move and copy I can only
insert one worksheet into the other workbook.

Please advise
--
Kellie
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11,058
Default Move and Copy

Assuming Book1 is Active and Book2 is already open as well:

Sub Macro1()
Sheets(Array("s1", "s2")).Copy Befo=Workbooks("Book2").Sheets(1)
End Sub

--
Gary''s Student - gsnu200755


" wrote:

Working with Excel 2003 - I am trying to place a previous work spreadsheet
into another workbook - however, when I attempted to move and copy I can only
insert one worksheet into the other workbook.

Please advise
--
Kellie

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 8,856
Default Move and Copy

If you have both workbooks open, with both file windows visible (use
Window | Arrange | Horizontal to see them both), then you can just
CTRL-drag the worksheet tab from one window to the other to create an
exact copy in the second workbook, i.e. hold down the CTRL key and
drag the tab from one window to the other using the mouse.

Hope this helps.

Pete

On Nov 12, 2:02 am,
wrote:
Working with Excel 2003 - I am trying to place a previous work spreadsheet
into another workbook - however, when I attempted to move and copy I can only
insert one worksheet into the other workbook.

Please advise
--
Kellie



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
Can not copy or move some worksheet NTNH Excel Worksheet Functions 1 May 28th 07 12:14 PM
Move/Copy or Copy/Insert worksheet? kjk Excel Discussion (Misc queries) 0 December 15th 06 03:40 PM
Move or Copy helen Excel Discussion (Misc queries) 2 November 8th 06 09:15 PM
copy-move question nastech Excel Discussion (Misc queries) 1 January 31st 06 04:16 AM
Copy Sheet and move to end Nigel Excel Discussion (Misc queries) 1 August 9th 05 05:09 PM


All times are GMT +1. The time now is 03:34 AM.

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"