Macro to copy multiple sheets x amount of times.

A

Andy_E

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Combine Data from Multiple Sheets with Cell References 4
OnTime Change_Event macro AND copy to sheet2 macro trouble 7
Macro to Compile Data from Different Sheets 2
Copy ranges from several sheets to another one in a vertical position 1
Addings sheets using Macro 4
Create Sheets from a Range and Copy Data on copy Data on newlycreated Sheets with the Sheet Names 2
Formatting and copy or copy and formatting ?? 2
Copy / Insert n Rows of data simultaneously to 3 worksheets, same workbook 2

Top