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.
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.