Download the featured invoice template here
https://www.bluepecantraining.com/excel-invoice-template/

Full playlist for this video series: https://youtube.com/playlist?list=PLA3JEasWtYad0OeX78k0gFhxm5qnnaD57

Check out Simple Sheets Invoice Template (all purchases help support this channel)
https://www.simplesheets.co/a/2147525377/v7Aj9zMx

This tutorial is part of a series of tutorials that demonstrate how to create an automated invoice system in Microsoft Excel. This video looks writing a VBA macro that clears the current invoice and automatically generates the next invoice number.

Other videos in this series show you how to write VBA macros that
1) Create the invoice itself
2) Add the invoice details to a record of invoices
3) Save the invoice as an Excel workbook or as a PDF
4) Automatically email a PDF version of the invoice to the customer

Table of Contents:

00:00 - Introduction
02:15 - VBA code to create next invoice number and clear current invoice
06:27 - Use IFNA to hide VLOOKUP #N/A errors
07:32 - Create a button to run the VBA macro
------------------------