How to automatically generate invoice number in Excel

As we know, invoice numbers are consecutive. If we input invoice numbers manually, we may forget the invoice number last time we used, and get overlapping number for the new invoice in Excel. In this article, I will introduce two methods to automatically generate invoice numbers in Excel easily.

More details:

[WayneThompson-ohbn]

This would have been 10 x easier, if you simply written the code in the comments for anyone to copy and paste. We would only have had to change the cell number if our excel workbook invoice template was not exactly the same as yours.