Tags Tags

HOW DO I DUPLICATE ONE SHEET MULTIPLE TIMES

June 03rd, 2010 - 05:46 pm ET by LC | Report spam
Help Create a new topic
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.
email Follow the discussionReplies 3 repliesReplies Make a reply

Replies

#1 Don Guillett
June 03rd, 2010 - 06:06 pm ET | Report spam
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
news:
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.

Similar topics

Make your own search :