Copy Multiple Sheets

G

Greg Rivet

How can I copy multiple sheets (2-5) to a new workbook. I know I can do a
savea as, but then I lose the original, unless I reopen it. TIA

Greg
 
K

Ken Wright

Click on the tab for sheet 2, hold down shift and then click on the tab for sheet 5. Now right
click and select 'move or copy', then select new book from the top dropdown, tick the 'create a
copy' at the bottom of the dialog box and hit OK.
 
K

Ken Wright

How would you want to pick them, and are you looking to have this be part of a bigger routine??

The hardcoded routine would be along the following lines:-

Sub CopySheets()
Sheets(Array("WS1", "WS2", "WS3", "WS4")).Copy
End Sub
 
S

Sandy

-----Original Message-----
How can I copy multiple sheets (2-5) to a new workbook. I know I can do a
savea as, but then I lose the original, unless I reopen it. TIA

Greg


.
Highlight sheet 2 and Try Edit - Move or Copy Sheet to a
Click to expand...
New Workbook and continue for sheets 3-5.
 
Top