Macro to copy multiple sheets x amount of times.

Joined
Apr 12, 2011
Messages
1
Reaction score
0
I am trying to create a template sheet and need to generate multiple sheets by copying a specific sheet.

I would like to be prompted for the number of sheets to copy.

can anybody help me with the correct text for a macro, to firstly copy the specific sheet and then prompt for the number of copies required.

Thanks for any help available.
 
Back
Top