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

*****UPDATE: I've modified the code that deletes all the shapes on the worksheet, so that it doesn't delete your logo. Download the template or see my reply to the pinned comment to get the modified version of the code. Thanks to Ron Bemis for pointing this out. *****

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 at how to write a VBA macro that saves the invoice worksheet to a new workbook and then automatically records it on the invoice tracker.

Other videos in this series show you how to write VBA macros that
1) Automatically generate the next invoice number
2) Add the invoice details to a record of invoices
3) Save the invoice as a PDF
4) Automatically email a PDF version of the invoice to the customer

Table of Contents:

00:00 - Introduction
03:00 - Start writing the code for the VBA macro
05:14 - Declaring variables for the macro
08:26 - VBA to copy specific worksheet to new workbook and save
09:07 - VBA to delete all shapes on a worksheet
09:48 - VBA to save a workbook to specified folder & use cell value as filename
12:44 - VBA to find next blank row
14:20 - Copy invoice details to invoice tracker
15:41 - VBA to create a hyperlink to link to another Excel workbook
17:22 - Create a button to run the macro
------------------------