Sequential numbers when printing

[Guest]

I have a form that I would like to have an autonumber (sequential) update
each time the form is printed. Is there a way to do this? It is a physician
invoice form that will be filled out by hand, but we need a new number each
time it is printed. Thanks!

 

[Niek Otten]

Hi Marilyn,

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a form that I would like to have an autonumber (sequential) update
| each time the form is printed. Is there a way to do this? It is a physician
| invoice form that will be filled out by hand, but we need a new number each
| time it is printed. Thanks!

 

[Guest]

Nick,
I did look at that. However, my background is nursing and training, not IT.
I don't know very much about visual basics. Is there a way to work in Excel
to do it, and not VB?

 

[Guest]

There is no way to do it without VB.

press ALT+F11 to open a new module, than copy and paste the code as Niek
show you

hth
regards from Brazil
Marcelo

"Marilyn, Training Coordinator" escreveu: