👉 Explore All My Excel Solutions: pythonandvba.com/solutions
𝗗𝗘𝗦𝗖𝗥𝗜𝗣𝗧𝗜𝗢𝗡
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
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: github.com/Sven-Bo/automate-excel-with-vba-and-chatgpt
⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
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
𝗧𝗢𝗢𝗟𝗦 𝗔𝗡𝗗 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🆓【𝗙𝗥𝗘𝗘】Excel Add-in (𝗠𝘆𝗧𝗼𝗼𝗹𝗕𝗲𝗹𝘁): pythonandvba.com/mytoolbelt
📊 Dashboard Excel Add-In (𝗚𝗿𝗮𝗳𝗹𝘆): pythonandvba.com/grafly
🎨 Cartoon Charts Excel Add-In (𝗖𝘂𝘁𝗲𝗣𝗹𝗼𝘁𝘀): pythonandvba.com/cuteplots
🤪 Fun Emoji Excel Add-In (𝗘𝗺𝗼𝗷𝗶𝗳𝘆): pythonandvba.com/emojify
📑 Excel Templates: pythonandvba.com/go/excel-templates
🎓 My Courses: pythonandvba.com/go/courses
📚 Books, Tools, and More: pythonandvba.com/resources
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘
▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀▀
🔗 LinkedIn: linkedin.com/in/sven-bosau/
📸 Instagram: instagram.com/codingisfun_official
💻 GitHub: github.com/Sven-Bo
💬 Discord: pythonandvba.com/discord
📬 Contact: pythonandvba.com/contact
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲?
If you want to support this channel, you can buy me a coffee here:
▶ pythonandvba.com/coffee-donation
- ChatGPT: Automating Excel with VBA like never before 🤯 ( Download)
- Use ChatGPT to Automate Excel VBA Macros ( Download)
- How to use ChatGPT to create Advanced Macros in VBA for Excel ( Download)
- How to Generate Excel VBA Code 10x Faster with ChatGPT ( Download)
- Excel with ChatGPT (Use Excel VBA Like a Pro with ChatGPT) ( Download)
- Automating Excel VBA with Chat GPT: VBA Macro Coding Made Easy | Episode 07 ( Download)
- How To Use ChatGPT and Excel VBA to Automate BORING Office Tasks ( Download)
- Let’s write some VBA for running macros in Excel using ChatGPT. ( Download)
- How to use ChatGPT to maximize your VBA skills ( Download)
- Automate Excel Using ChatGPT (SURPRISING results) ( Download)
- Excel How To Understand VBA with ChatGPT ( Download)
- Excel Pro Trick: Write Excel VBA Codes using ChatGPT AI Artificial Intelligence - VBA Code Tutorial ( Download)
- Using VBA code to automate Excel tasks with ChatGPT ( Download)
- 10X Your Excel Skills with ChatGPT 🚀 ( Download)
- Automate Boring Office Tasks with ChatGPT and Python ( Download)
