ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Increment an Invoice number (https://www.excelbanter.com/excel-worksheet-functions/6379-re-increment-invoice-number.html)

Gwyneth

Increment an Invoice number
 
I find all this very confusing - I am not that computer literate. How do I
save the last invoice number to a cell - will it automatically change with
each new invoice or will I have to type it in each time?

" wrote:

Depending on the complexity of use required, you can save
last invoice number to a cell (or add it to a list of
numbers), then simply add the increment to that number for
the new invoice.


-----Original Message-----
I have an Invoice template, which is used with SaveAs to

create a new invoice. Can the invoice numbers be
automatically incremented?
--
Les
.



JulieD

Hi

if you'ld like to email me (julied_ng at hcts dot net dot au) direct i can
send you a sample workbook, that you might be able to adapt to your needs ..

Cheers
JulieD

"Gwyneth" wrote in message
...
I find all this very confusing - I am not that computer literate. How do I
save the last invoice number to a cell - will it automatically change with
each new invoice or will I have to type it in each time?

" wrote:

Depending on the complexity of use required, you can save
last invoice number to a cell (or add it to a list of
numbers), then simply add the increment to that number for
the new invoice.


-----Original Message-----
I have an Invoice template, which is used with SaveAs to

create a new invoice. Can the invoice numbers be
automatically incremented?
--
Les
.






All times are GMT +1. The time now is 07:26 PM.

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