Printing sequential numbers

[BMI]

I have created a form in excel. I will be using this form to print many duplicates of the same form but I need the forms to have numbers sequentially printed on them (ie. Ticket 001, 002, 003, etc.) Is there a way to make excel do this?

If so, can I print form numbers 001-303 and then come back later and tell excel to start printing the form using the beginning number 304-477 or whatever number I choose? Thank you!

 

[Sally Alice]

Hi Mr. Excel,
What would need to be added to this code to:
-- place the sequential number in an exact cell location so it prints on the form in the right place (not at the top); and
-- add a leading zero to a number based on a date, e.g., 050818-01 ?
Thank you!

 

[Sally Alice]

Hi Mr. Excel,
What would need to be added to this code to:
-- place the sequential number in an exact cell location so it prints on the form in the right place (not at the top); and
-- add a leading zero to a number based on a date, e.g., 050818-01 ?
Thank you!

 

[John Valencia]

I created a documents that needs to have control numbers, examples are 1001,1002,1003,1004,1005,1006,1007,1008,1009 and 1010.

 

[KAYE04]

hI, I having a hard time understanding what macros is?
can i ask help from you guys.
same with the problem of BMI.

"I will be using this form to print many duplicates of the same form but I need the forms to have numbers sequentially printed on them (ie. Ticket 001, 002, 003, etc.) Is there a way to make excel do this?

If so, can I print form numbers 001-303 and then come back later and tell excel to start printing the form using the beginning number 304-477 or whatever number I choose? "


THANK YOU SO MUCH

 

[HollyAnn73]

This is almost completely perfect for what I'm looking to do except I need the number to be on each sheet of the print job. I am printing a workbook with about 10 pages, each of which should have the "ID number" of that particular workbook. So, all pages of the first printjob of 10 pages will be 10001, on the next printjob all 10 pages will have 10002 on them... and so on. This will save me a whole lot of handwriting!

I tried messing with the range in the first macro you gave and also variations of ActiveWindow.SelectedSheets.PrintOut.

 

[sethbrad]

i keep getting an error 6 my code is exactly as above, we normally use numbers are are 200*******, 10 digits total, we have transitioned to 10 digits starting with 500*******, how to I adjust the formula to account for this larger number