Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying more that one Worksheet at a time.
How are you all,
i was wondering if it was possible to copy more than one sheet at a time - i have a work book and i need to make multiple copies of one particular sheet, when i right click on a work sheet tab there are the options there - one of them is move or copy - when you copy it askes where to put it, when you do that it only comes up with one extra sheet - is it all possible to paste a few more at a time than just one? Thanks heaps Patchie |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying more that one Worksheet at a time.
I can't see how to do that without some programming.
What you can do is 'double up' though. This way you can create lots of sheets fairly fast. So, (A) select a sheet, drag it sideways (left button), hold control (+ icon shows), drop (now you have 2 sheets) (B) select the first sheet, hold down control and select the new sheet. Release. Now you have 2 sheets selected (two white ones). Click on one of them, drag it sideways, hold control (now you see +++ icon), release. (now you have four sheets). (C) now you need to do the same to double up those 4 sheets to 8 sheets. You should be able to get to the number of sheets you need pretty quickly like this. -- Allllen "Patch" wrote: How are you all, i was wondering if it was possible to copy more than one sheet at a time - i have a work book and i need to make multiple copies of one particular sheet, when i right click on a work sheet tab there are the options there - one of them is move or copy - when you copy it askes where to put it, when you do that it only comes up with one extra sheet - is it all possible to paste a few more at a time than just one? Thanks heaps Patchie |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying more that one Worksheet at a time.
Patch
You cannot copy multiples of the same sheet at once unless you have multiple copies of the sheet. In that case you could select all copies of Sheet1 and use the "move or copy" feature. You have one other response describing how to double up to create multiples of a sheet. OR you could use a macro............. Sub SheetCopy() Dim i As Long On Error GoTo endit Application.ScreenUpdating = False shts = InputBox("How many times") For i = 1 To shts ActiveSheet.Copy after:=ActiveSheet Next i Application.ScreenUpdating = True endit: End Sub Gord Dibben MS Excel MVP On Fri, 29 Sep 2006 01:15:51 -0700, Patch wrote: How are you all, i was wondering if it was possible to copy more than one sheet at a time - i have a work book and i need to make multiple copies of one particular sheet, when i right click on a work sheet tab there are the options there - one of them is move or copy - when you copy it askes where to put it, when you do that it only comes up with one extra sheet - is it all possible to paste a few more at a time than just one? Thanks heaps Patchie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying a linked worksheet | Excel Worksheet Functions | |||
How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
Sorting and copying data to another worksheet in a workbook. | Excel Discussion (Misc queries) | |||
Question when Copying an Existing Worksheet | Excel Worksheet Functions | |||
Copying Numerical Totals of separate worksheets to a single Summary Worksheet | Excel Discussion (Misc queries) |