Sequential numbers when printing
 

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!

Sequential numbers when printing
 

Hi Marilyn,

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Marilyn, Training Coordinator" <Marilyn, Training wrote in message
...
|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!

Sequential numbers when printing
 

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?

"Niek Otten" wrote:

Hi Marilyn,

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Marilyn, Training Coordinator" <Marilyn, Training wrote in message
...
|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!

Sequential numbers when printing
 

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:

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?

"Niek Otten" wrote:

Hi Marilyn,

Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Marilyn, Training Coordinator" <Marilyn, Training wrote in message
...
|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!