MS Excel — An #excel automation tip EVERY professional should use!

Use ChatGPT to automate printing worksheets to PDF

Don Tomoff
Let’s Excel


Leila Gharani, Excel MVP, recently shared a great video on how you could use ChatGPT to augment your work in Microsoft Excel.

There is a ton of opportunity to take your productivity to another level by taking advantage of this new artificial intelligence chatbot.

In that video, her last example was how to create an automation routine to print a worksheet, selected via a Dropdown list, that will automatically

👉 generate a PDF

👉 Name the PDF the same as the worksheet name, and

👉 Save it to the same folder the workbook is in.

Even if you have never used macros, you can do this.

EVERY professional can use this technique. Just do it! Check out that tip in the video below!

In case your interested, the full list of topics in Leila’s video are:

1️⃣ 00:00 How to Use ChatGPT with Excel

2️⃣ 00: 52 Write Excel Formula with ChatGPT

3️⃣ 05:06 Data Validation

4️⃣ 08:42 Nested IF Formulas with ChatGPT

5️⃣ 12: 42 Writing VBA Code

6️⃣ 17:14 Wrap Up

Leila, thanks for the video and, in particular, this one fantastic example. Well done!

This post was originally posted on LinkedIn — follow me on LinkedIn and follow #twinztalk as well!

About Don

“It’s time for different”

Connect with me!

LinkedIn, Flipboard, Twitter, Snapchat



Don Tomoff
Let’s Excel

It’s time for DIFFERENT— On a mission to challenge the status quo to a more productive and effective end… #digital #Excel #data #analytics #genai #chatgpt