How can I generate a unique number each time a form is printed?

G

Guest

I have to create a form to use for inventory moves. I want the form to have
a unique control number each time it is printed. This way they can be signed
out and then signed in once the material handlers are done for the day. This
way I can keep track if one is not turned back in.
 
N

Niek Otten

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have to create a form to use for inventory moves. I want the form to have
| a unique control number each time it is printed. This way they can be signed
| out and then signed in once the material handlers are done for the day. This
| way I can keep track if one is not turned back in.
 

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

How do I get a unique number on a form when I open it each time? 2
How do I create a drop down list that fills multiple cells? 1
how to generate a unique form # when using an excel form template 1
Increment control number at print time 2
Unique number 4
printing blank forms with auto generated numbers 4
Sumproduct but only first time corresponding value is seen e.g. un 1
How can excel generate every unique pair from a set of numbers? 4

Top