Home |
Search |
Today's Posts |
#1
|
|||
|
|||
serial number cell
How can I set up a serial number cell such as an invoice number that
automatically increases by one each time I need a new invoice? |
#2
|
|||
|
|||
Take a look he
http://www.mcgimpsey.com/excel/sequentialnums.html In article , LGCoop wrote: How can I set up a serial number cell such as an invoice number that automatically increases by one each time I need a new invoice? |
#3
|
|||
|
|||
On Fri, 9 Sep 2005 20:30:05 -0700, LGCoop
wrote: How can I set up a serial number cell such as an invoice number that automatically increases by one each time I need a new invoice? How are you setting up a new invoice? Are you for instance using a VBA macro attached to a button which opens up an invoice template? If so you could hold the invoice number variable in a named cell, and simply increase it with an extra line of code in the macro. e.g. Range("InvoiceNoVariable")=Range("InvoiceNoVariabl e") + 1 HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I have a progressive number in the same cell when printing? | Excel Worksheet Functions | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
16 digit number wont keep alteration unless format cell to text | Excel Discussion (Misc queries) | |||
Excel should let me circle a cell or number in the spreadsheet fo. | Excel Discussion (Misc queries) | |||
How do I format a cell for a custom part number? | Excel Discussion (Misc queries) |