Posted to microsoft.public.excel.worksheet.functions
|
|
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!
|