Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can not copy or move some worksheet | Excel Worksheet Functions | |||
Move/Copy or Copy/Insert worksheet? | Excel Discussion (Misc queries) | |||
Move or Copy | Excel Discussion (Misc queries) | |||
copy-move question | Excel Discussion (Misc queries) | |||
Copy Sheet and move to end | Excel Discussion (Misc queries) |