| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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! |
|
#4
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is this a known excel error?? Sequential drag down & IF ERRORS?? | Excel Worksheet Functions | |||
| Is this a known excel error?? Sequential drag down & IF ERRORS?? | Excel Worksheet Functions | |||
| Make sequential numbers each time sheet is opened | Excel Worksheet Functions | |||
| How do I assign sequential numbers in an invoice? | New Users to Excel | |||
| sequential numbers on invoices | Excel Worksheet Functions | |||
Linear Mode
