MULTIPLE COPYING OF ONE WORKSHEET
 

hello:
i have a worksheet with labels and formulas, (call it worksheet 2) and i
wouldlike to have multiple copies of it(worksheets 3-14). how do i accomplish
this?

excel 2007
--
thanx
jmh

MULTIPLE COPYING OF ONE WORKSHEET
 

Right-click on the sheet tab, then take the "Move or Copy ..." option.
--
David Biddulph


"jmh" wrote in message
...
hello:
i have a worksheet with labels and formulas, (call it worksheet 2) and i
wouldlike to have multiple copies of it(worksheets 3-14). how do i
accomplish
this?

excel 2007
--
thanx
jmh

MULTIPLE COPYING OF ONE WORKSHEET
 

Sub SheetCopy12()
Dim i As Long
Dim ws As Worksheet
Set ws = Sheets("Sheet2")
On Error GoTo endit
Application.ScreenUpdating = False
For i = 14 To 3 Step -1
ws.Copy After:=ws
With ActiveSheet
.Name = "Sheet" & i
End With
Next i
Application.ScreenUpdating = True
endit:
End Sub


Gord Dibben MS Excel MVP

On Sat, 27 Feb 2010 11:26:01 -0800, jmh wrote:

hello:
i have a worksheet with labels and formulas, (call it worksheet 2) and i
wouldlike to have multiple copies of it(worksheets 3-14). how do i accomplish
this?

excel 2007