Auto numbering of Invoice in excel

0

Hi. I need to create auto invoice number in excel, and also save detail of each invoice for further data analysis.

Answer
Discuss

Answers

0

In order to know the next number you must record the last used number somewhere. The most suitable place is a worksheet dedicated to that purpose and hidden. If you wish to record details of invoices issued that could be done on the same sheet.

The next decision you will have to make is whether to use VBA or try do without it.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login