Automatically number copied worksheets

[straightexhaust]

First I want to say hello and thanks for any help I may receive,

The company I work for uses excel with macros a lot! I decided to try to make my own today modifying some code that I've found on the web. What I am trying to do is prompt a user to name the beginning sheet, then copy that sheet x times (prompt user) while incrementing the name.

Example user types "B1-01", then user enters 4 for number of copies and the results are sheets B1-01, B1-02, B1-03, B1-04, B1-05

Some code found on this site from thread:

http://www.excelforum.com/excel-prog...-3-digits.html

What I have so far: (Yes I know, I have no clue what I'm doing, I just took a java class in high school and trying to remember/adapt)

Please Login or Register  to view this content.

[Leith Ross]

Hello straightexhaust,

Welcome to the Forum!

When you say "What I am trying to do is prompt a user to name the beginning sheet", do you mean the user should enter the name of an existing sheet or enter a name he or she makes up?

[straightexhaust]

I was planning on having them enter the name of an existing one, so that they would open excel and create a sheet of each different commissioning sheet they needed and then when prompted say which one they wanted and be able to make copies of it. The only real reason I wanted to do this is if they need to go back and make copies of a sheet and there are 20 different types of sheets in there they could select a specific one to make copies of.

I'm not sure how else to word it I hope you understand

Jason