Using ChatGPT to Generate Excel Formulas and VBA Macros

Since its launch in November 2022, ChatGPT has become a versatile AI tool capable of chatting, coding, and generating Excel formulas. The article explores integrating ChatGPT into everyday office applications like Word, PowerPoint, and especially Excel to improve efficiency.

It begins by guiding readers to create a ChatGPT account (https://chat.openai.com/auth/login) and explains how natural‑language prompts can replace manual formula writing. For a simple sum of the Expenses column, a prompt yields a ready‑to‑use =SUM(B2:B13) formula that can be placed in cell B14.

More complex tasks are illustrated, such as counting months with expenses over $100,000 using =COUNTIF(...) , and summing unpaid fees with =SUMIF(...) . The article also shows how to extract area codes from phone numbers with the formula =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1) , and how to count unique area codes using =SUMPRODUCT(1/COUNTIF(B2:B9,B2:B9)) .

Beyond formulas, the tutorial covers creating a VBA macro to sort worksheets by tab name. It presents the macro code, discusses debugging steps when ChatGPT generates errors, and notes that the final macro may rename a tab to temp during sorting.

Overall, the guide showcases practical examples of prompting ChatGPT to automate Excel tasks, generate accurate formulas, and write VBA code, highlighting AI’s value for users who struggle with Excel’s built‑in functions.