ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Invoice Numbers (https://www.excelbanter.com/excel-discussion-misc-queries/10592-invoice-numbers.html)

Russ

Invoice Numbers
 
I am having trouble with automating invoice numbers. I have been using the
date with a different number format for this, but this is not what I want. I
could use some help with the formula

Otto Moehrbach

Russ
By "automating invoice numbers" do you mean automatically incrementing
the invoice number?
If so, this is simple to do with an event macro. But you have to come
up with when you want the incrementing to take place. When you open the
file? When you print the invoice? When you save the file? When you close
the file? Post back with your answer. HTH Otto
"Russ" wrote in message
...
I am having trouble with automating invoice numbers. I have been using the
date with a different number format for this, but this is not what I want.
I
could use some help with the formula





All times are GMT +1. The time now is 02:47 PM.

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