ChatGPT: Automating Excel with VBA like never before ๐Ÿคฏ

In this video, I'm going to show you how I use VBA and ChatGPT to automate some pretty tedious Excel tasks. We'll be consolidating data, sending mass emails with personalized text and attachments, and even automating pivot table creation. I'll walk you through step by step, showing you how easy it is to use ChatGPT to generate the VBA code for these tasks, and how little effort it takes to implement them in your own workbooks. So, come along with me and let's make Excel work for us, instead of the other way around!

๐ŸŒŽ ๐—ฅ๐—˜๐—ฆ๐—ข๐—จ๐—ฅ๐—–๐—˜๐—ฆ:
The Excel files can be found here:

โญ ๐—ง๐—œ๐— ๐—˜๐—ฆ๐—ง๐—”๐— ๐—ฃ๐—ฆ:
00:00 โ€“ Intro
00:26 โ€“ 1. Example: Extract data from multiple files
02:15 โ€“ 2. Example: Send personalized emails
05:59 โ€“ 3. Example: Find and replace values
08:15 โ€“ 4. Example: Create pivot tables and charts
10:15 โ€“ Outro

โ—ผ๏ธโ—ผ๏ธโ—ผ๏ธโ—ผ๏ธโ—ผ๏ธโ—ผ๏ธโ—ผ๏ธโ—ผ๏ธโ—ผ๏ธโ—ผ๏ธโ—ผ๏ธโ—ผ๏ธโ—ผ๏ธโ—ผ๏ธโ—ผ๏ธโ—ผ๏ธโ—ผ๏ธ
๐—–๐—ข๐—ก๐—ก๐—˜๐—–๐—ง ๐—ช๐—œ๐—ง๐—› ๐— ๐—˜:
๐ŸŒŽ Website:
๐Ÿ“ GitHub:
โญ Discord:
โ–ถ๏ธ Subscribe:

๐ŸŽ‰ ๐—™๐—ฅ๐—˜๐—˜ ๐—˜๐˜…๐—ฐ๐—ฒ๐—น ๐—”๐—ฑ๐—ฑ-๐—ถ๐—ป ๐˜๐—ผ ๐—ฏ๐—ผ๐—ผ๐˜€๐˜ ๐˜†๐—ผ๐˜‚๐—ฟ ๐—ฝ๐—ฟ๐—ผ๐—ฑ๐˜‚๐—ฐ๐˜๐—ถ๐˜ƒ๐—ถ๐˜๐˜†
Get it here:

๐Ÿ“š ๐—ฅ๐—ฒ๐˜€๐—ผ๐˜‚๐—ฟ๐—ฐ๐—ฒ๐˜€ ๐—ณ๐—ผ๐—ฟ ๐—น๐—ฒ๐—ฎ๐—ฟ๐—ป๐—ถ๐—ป๐—ด ๐—ฉ๐—•๐—” & ๐—ฃ๐˜†๐˜๐—ต๐—ผ๐—ป
Check out my recommendations:

โ˜• ๐—•๐˜‚๐˜† ๐—บ๐—ฒ ๐—ฎ ๐—ฐ๐—ผ๐—ณ๐—ณ๐—ฒ๐—ฒโ“
If you want to support this channel, you can buy me a coffee here:

Leave a Reply

Your email address will not be published. Required fields are marked *

Amazon Affiliate Disclaimer

Amazon Affiliate Disclaimer

โ€œAs an Amazon Associate I earn from qualifying purchases.โ€

Learn more about the Amazon Affiliate Program