Move and Copy

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jessica@aol.com - 12 Nov 2007 02:02 GMT

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

Signature

Kellie

Reply to this Message

Gary''s Student - 12 Nov 2007 10:52 GMT

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

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

Signature

Gary''s Student - gsnu200755

> 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

Reply to this Message

Pete_UK - 12 Nov 2007 11:42 GMT

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, Jess...@aol.com
<Jessicaaol...@discussions.microsoft.com> 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
[quoted text clipped - 3 lines]
> --
> Kellie

Reply to this Message

Rate this thread: