'move or copy' a single worksheet multiple times

[DebC]

In Office 2003, when I right click a tab in a workbook and get the option of
'move or copy' is it possible to 'copy' a worksheet multiple times all at
once?

 

[Peo Sjoblom]

No, but if you make a copy once then you can select both those sheets and
right click and now you will get 4 copies and next time 8 and so on. So the
answer is no, not by using anything built in except for VBA

--


Regards,


Peo Sjoblom

 

[Jim Thomlinson]

An easier way to copy a sheet is to hold down the control key and drag the
sheet (or sheets). When you do this you will see a + sign while dragging
indicateing you are copying the sheet. Doing this it does not take long to
get a fairly substantial number of copies.

 

[DebC]

ok, that's what I thought, and have done that. Just wondered. Thanks so
much!
Have a good day.

 

[DebC]

Thanks, Jim!

An easier way to copy a sheet is to hold down the control key and drag the
sheet (or sheets). When you do this you will see a + sign while dragging
indicateing you are copying the sheet. Doing this it does not take long to
get a fairly substantial number of copies.

 

[Gord Dibben]

Manually......................

Copy once then select both sheets and copy again then select the 4 sheets
and copy again

Via VBA....................

Asign this macro to button or shortcut key combo.

Sub SheetCopy()
Dim i As Long
On Error GoTo endit
Application.ScreenUpdating = False
shts = InputBox("How many times", , 3) '3 is default
For i = 1 To shts
ActiveSheet.Copy After:=ActiveSheet
Next i
Application.ScreenUpdating = True
endit:
End Sub


Gord Dibben MS Excel MVP

 

[Peo Sjoblom]

I have done that at times but I really don't think it is easier
than selecting a group of sheets and then right click.
It's handy when you want to move a sheet a few steps (without using the ctrl
key)
but I feel like I have less control.

--


Regards,


Peo Sjoblom

 

[DebC]

The macro is absolutely wonderful! This will save me sooooo much time.
Thank you, thank you, thank you.

 

[Gord Dibben]

Glad to help

Thanks for the feedback.


Gord

The macro is absolutely wonderful! This will save me sooooo much time.
Thank you, thank you, thank you.