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!

Hi Marilyn,

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Marilyn, Training Coordinator" <Marilyn, Training [email protected]> wrote in message
news:[email protected]...
|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!

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 here:
>
> http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "Marilyn, Training Coordinator" <Marilyn, Training [email protected]> wrote in message
> news:[email protected]...
> |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!
>
>
>

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 here:
> >
> > http://www.mcgimpsey.com/excel/udfs/sequentialnums.html
> >
> > --
> > Kind regards,
> >
> > Niek Otten
> > Microsoft MVP - Excel
> >
> > "Marilyn, Training Coordinator" <Marilyn, Training [email protected]> wrote in message
> > news:[email protected]...
> > |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!
> >
> >
> >

Hi there!

I am new in this forum and I think it will help me out of trouble. I am new in vba code so your patience will surely appreciated.

I want to print an invoice with 4-digits simultaneous number. Please help me so.


Regards.