On Dec 1, 5:33 pm, "Don Guillett" wrote:
Sub copysheet()
Sheets("Template").Copy after:=Sheets(Sheets.Count)
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"vdmbqb" wrote in message

...



I have a two page workbook. Page 1 is instructions for the information
expected on page two. Page 2 is called Customer Info.

I would like to have a button on page 1 that I could simply click on that
would add another Customer Info page with each click.
--
bob- Hide quoted text -

- Show quoted text -

Hi Don,

How would you do it so the new sheet will be named Sheet3 than
'Sheet1 (2)?

--Jim