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: