Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I change the invoice number assigned in Invoice template...
I would like to change the starting value of the number assigned to the
Invoice number on the Invoice template when clicking on the "Assign a Number" button on the Invoice toolbar. |
#2
|
|||
|
|||
Does the "assign a number" button already exist? If yes, then hide
your starting number somewhere on your sheet- this will allow to Excel to remember the number from use to use. Then have the code associated with the button retrieve that number, augment it by one so the next number is ready for use on the next invoice, and then add or apply the number (now stored in memory) to your invoice number cell on the template. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Histograms: how change number of bins | Excel Discussion (Misc queries) | |||
How do I automatically pull a new invoice number into an excel te. | Excel Discussion (Misc queries) | |||
updating invoice number on excel spreadsheet | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions | |||
Increment an Invoice number | Excel Worksheet Functions |