Скачать с ютуб Save Invoice Worksheet to New Workbook | Filename Based on Cell Value | Create Hyperlink to Invoice в хорошем качестве

Save Invoice Worksheet to New Workbook | Filename Based on Cell Value | Create Hyperlink to Invoice

👍👍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... Thank you! 👍👍 Alternatively buy the Simple Sheets Invoice Template (all purchases help support this channel) https://www.simplesheets.co/a/2147525... Download the featured invoice template here https://www.bluepecantraining.com/exc... ****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:    • Create an Automated Invoice Template,...   Check out Simple Sheets Invoice Template (all purchases help support this channel) https://www.simplesheets.co/a/2147525... 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 ------------------------