Prev: Conditionally formatting a cell based on other cell values
Next: Count Wednesdays within a calendar month
From: jmh on 27 Feb 2010 14:26
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
From: "David Biddulph" groups [at] on 27 Feb 2010 14:44
Right-click on the sheet tab, then take the "Move or Copy ..." option.
--
David Biddulph


"jmh" <bbb(a)yahoo.com> wrote in message
news:EBF879A7-24E0-4539-99B5-CDE9513136AE(a)microsoft.com...
> 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


From: Gord Dibben on 27 Feb 2010 15:20
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 <bbb(a)yahoo.com> 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

 | 
Pages: 1
Prev: Conditionally formatting a cell based on other cell values
Next: Count Wednesdays within a calendar month