At work, I had repetitive Excel tasks every day (data cleaning, creating pivot tables, updating charts), so I asked ChatGPT to write VBA macros for me.
The method is simple. 1) Describe the task you want in natural language (e.g., "Filter data based on dates in column A, and create a pivot table with the sums of columns B to D on a new sheet") 2) Paste the VBA code generated by ChatGPT into the Excel VBA editor 3) Run it—done.
At first, the code sometimes had errors, but copying the error message and asking again fixed it. Now, tasks that used to take 30 minutes are done in 1 minute, which is incredibly convenient.
If you have any other automation tips, please share!