Macro to Create New Renamed Page from Template

[b0ttle]

Hey guys,

Quick question,

I have a template and im trying to make a macro'd button that on a click will take the template, copy it and rename it in consecutive order

Such as if i click the button once, I should see a "template" named as "1", click it again, named as "2" and so on

How would I go on about doing this?

Thanks

[Miroslav R.]

Hi there,
In the case Your template sheet name is number You can run this from template-to-copy sheet.

Please Login or Register  to view this content.

Is this what You are looking for?