If you need a way to create invoices in Excel, feel free to use one of the many invoice templates on Office.com. While these templates are a great starting point, they won’t automatically generate unique invoice numbers—you need a macro for that.
Fortunately, Excel MVP Bill Jelen shows you how to create a couple of macros to address this issue. The first macro automatically increments the invoice number and then clears cells on the worksheet so you can start fresh on the next invoice. The second macro lets you save a copy of the invoice with a unique file name. Enjoy!