Hi. I need to create auto invoice number in excel, and also save detail of each invoice for further data analysis.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Auto numbering of Invoice in excel
0
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.