| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
automatic sequential number on invoice or shippers
I made and invoice excel template and a shipper excel template. Each time I
open the worksheet to make an invoice, I want the number to change in the cell on the invoice or shipper. No duplicate numbers. How can I do this? |
|
#2
|
|||
|
|||
|
One way
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Regards, Peo Sjoblom (No private emails please) "jeannene" wrote in message ... I made and invoice excel template and a shipper excel template. Each time I open the worksheet to make an invoice, I want the number to change in the cell on the invoice or shipper. No duplicate numbers. How can I do this? |
|
#3
|
|||
|
|||
|
jeannene
Check out John McGimpsey's site for methods. http://www.mcgimpsey.com/excel/udfs/sequentialnums.html Gord Dibben Excel MVP On Thu, 6 Oct 2005 17:34:49 -0700, "jeannene" wrote: I made and invoice excel template and a shipper excel template. Each time I open the worksheet to make an invoice, I want the number to change in the cell on the invoice or shipper. No duplicate numbers. How can I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get automatic sequential numbering when using an invoice. | Excel Discussion (Misc queries) | |||
| How do I set up invoice automatic numbering in excel? | Excel Discussion (Misc queries) | |||
| Automatic Invoice Number | Excel Discussion (Misc queries) | |||
| Can I disable this automatic number advance thing? | Excel Discussion (Misc queries) | |||
| How do I automatically pull a new invoice number into an excel te. | Excel Discussion (Misc queries) | |||
Hybrid Mode
