ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I change the invoice number assigned in Invoice template... (https://www.excelbanter.com/excel-discussion-misc-queries/15336-how-do-i-change-invoice-number-assigned-invoice-template.html)

akress

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.

Dave O

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.



All times are GMT +1. The time now is 10:36 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com