Thread
:
HOW DO I DUPLICATE ONE SHEET MULTIPLE TIMES
View Single Post
#
2
June 3rd, 2010, 11:06 PM posted to microsoft.public.excel.misc
Don Guillett[_2_]
external usenet poster
Posts: 607
HOW DO I DUPLICATE ONE SHEET MULTIPLE TIMES
Sub makeshts()
For i = 1 To 21
Sheets("Template").Copy After:=Sheets(i)
Next i
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"LC" wrote in message
...
How do i copy data from one sheet to another, to include the footer and
header.
I created a log for work. I need 20 of them to be able to fit everyones
name
on it. I would like to have 20 separate sheets.
Am I able to have 20 sheets in excel?
Thank you.
Don Guillett[_2_]
View Public Profile
View message headers
Find all posts by Don Guillett[_2_]
Find all threads started by Don Guillett[_2_]