| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Invoice number that auto advances???
is it possible to program a cell within a Template to automatically advance
by one number each time a new sheet started? I am trying to program the "Invoice that calculates sales tax and total" to advance the invoice number automatically. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Invoice number that auto advances???
Hi
J E McGimpsey has a method for achieving this on his site at http://www.mcgimpsey.com/excel/udfs/sequentialnums.html -- Regards Roger Govier "merlin2ate" wrote in message ... is it possible to program a cell within a Template to automatically advance by one number each time a new sheet started? I am trying to program the "Invoice that calculates sales tax and total" to advance the invoice number automatically. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generate Auto Order Number | Excel Discussion (Misc queries) | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| Linking to a pivot table from a formatted invoice | Links and Linking in Excel | |||
| Master invoice number | Excel Worksheet Functions | |||
| updating invoice number on excel spreadsheet | Excel Worksheet Functions | |||
Linear Mode
