Excel VBA - Clear Invoice and Automate Next Invoice Number

👍👍This invoice is free for you to use - no strings attached. However, if you have found this content useful and want to show your appreciation, please use this link to buy me a beer 🍺. https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ Thank you! 👍👍 Alternatively buy the Simple Sheets Invoice Template (all purchases help support this channel) https://www.simplesheets.co/a/2147525377/v7Aj9zMx 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 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 ------------------------