Excel - Create sequentially numbered forms

Hi,
New to this forum and thought I saw a similar post, but can't find it.
I have a form that I've created in Excel that I need to print out and then be filled out by hand.
I want to be able to print the form in batches that are sequentially numbered based on a number that I can input into a non-printing area cell.
EG. if I need 25 forms, I want to be able to enter the "root" form number "210-" and the number of forms I need (e.g 25) and then to have each print with a unique number like "210-01", "210-02", through "210-25".
Thank you!

I have a code that works for me. It was provided by a member on the forum, I wish I could remember which. The problem with it is you can not use a dash "-". But it may be a start for you

Please Login or Register  to view this content.

P.S. Start with a number in row A and it will also store your numbers in the sheet.

I forgot to tell you to put it in Userform_Activate

Thanks for the quick response.
As a new-be I don't know how/where to use the code you gave me.
Barry

.210-25.xlsm
not sure what sunswan's code does exactly, but the code i'm giving you will put the 250-x, or what ever you choose, as a footer easily changeable to a header or even a cell

i put a button to do the actual printing, i'd try it with 2 pgs first just to see if it works the way you like it

Thanks for your macro.
I gave it a try and I think I found an error?
I'm printer was going crazy, printing countless copies.
I think, "Copies = r" should have been "Copies = 1"

What do I change ".CenterFooter =" to so I can printer the number in a specific cell (I'll need to also format it properly, but I can take care of that via cell formatting.
Thanks again,

I'm not sure if I ever said thank you?

THANK YOU!

Your help was great!