| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using a template form, advance a form number everytime you open
How could I set up a spreadsheet that will show one cell with a changing
number every time the spreadsheet is opened? I am attempting to make an invoice that will show an advancing number everytime I start a new one. I would save the form as a template. Once I save the form I don't want it to change again, it should remain the same. Example: 0012345 0012346 0012347 Thanks in advance John |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Using a template form, advance a form number everytime you open
hi
an often repeated request. see this site.... http://www.mcgimpsey.com/excel/udfs/sequentialnums.html regards FSt1 "ShoDan" wrote: How could I set up a spreadsheet that will show one cell with a changing number every time the spreadsheet is opened? I am attempting to make an invoice that will show an advancing number everytime I start a new one. I would save the form as a template. Once I save the form I don't want it to change again, it should remain the same. Example: 0012345 0012346 0012347 Thanks in advance John |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a unique number on a form when I open it each time? | Excel Worksheet Functions | |||
| Template form | Excel Worksheet Functions | |||
| how to generate a unique form # when using an excel form template | Excel Worksheet Functions | |||
| How do I add one to a number everytime I open the same workbook | Excel Worksheet Functions | |||
| how can I make a form number change everytime the form is opened | Excel Worksheet Functions | |||
Linear Mode
