1 SHEET into 100 sheet Workbook.

[STEVE]

Is there a quick way to copy 1 sheet into a 100 sheet workbook?

 

[Gord Dibben]

Copy from where?


Gord Dibben MS Excel MVP

 

[Rookie 1st class]

“Insert†“Worksheet†On the Standard toolbar.

 

[Rookie 1st class]

1. “Tools†“Options†on the “View tab†click “Sheet tabsâ€.
2. Right click the Tab (at bottom of sheet) you want to copy.
3. Select move or copy (you can even choose where to place the copied sheet).
4. Rename the new sheet.
Lou

 

[STEVE]

Duplicate 1 sheet in workbook "A" to 100 sheets in workbook "A".
A QUICK way!!! (not answers below since that is very slow and manual)

 

[Gord Dibben]

Sub SheetCopy22()
Dim i As Long
Application.ScreenUpdating = False
For i = 1 To 100
ActiveSheet.Copy Before:=Sheets(1)
Next i
Application.ScreenUpdating = True
End Sub


Gord