| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copying worksheet including graphs to new worksheet | Excel Discussion (Misc queries) | |||
| Copying from one worksheet to multiple worksheets | Excel Discussion (Misc queries) | |||
| Copying Cell from Multiple Worksheets to a Summary Worksheet | Excel Worksheet Functions | |||
| Looking up a variable in one worksheet and copying information from another column to another worksheet?? | Excel Discussion (Misc queries) | |||
| Copying a worksheet witrh protected cells to a new worksheet | Excel Worksheet Functions | |||
Linear Mode
