ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How can I generate a unique number each time a form is printed? (https://www.excelbanter.com/excel-worksheet-functions/105690-how-can-i-generate-unique-number-each-time-form-printed.html)

homaxlinda

How can I generate a unique number each time a form is printed?
 
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.

Niek Otten

How can I generate a unique number each time a form is printed?
 
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"homaxlinda" wrote in message ...
|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.




All times are GMT +1. The time now is 02:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com