What's Next For Accounting? - Issue #62

🤖 Automate My Thing

Write Your Excel Macros

I don't use a lot of excel macros, but it turns out ChatGPT is great at writing code. So let's give it a try!

We're using ChatGPT today, a free app from OpenAI. If you feed it a list of what you want the macro to do, it does fairly well:

Here I want to remove duplicate data from my sheet, so I created a new field that was a concatenation of all the other fields, and delete the duplicate records:

I did a deep dive on how to transform data with ChatGPT in this thread, and remember, if you don't know how to use a VBA script in excel, just ask ChatGPT!

💎This Week's Sponsor

👷‍♀️ This Week I Made

😍From The Community

My community Realize is a private space for people to swap ideas & collaborate. At $180/mo it’s also the way I finance everything else I do, pay a full-time creative director, and a part-time developer in an effort to make the accounting industry a slightly better place 💗 The community is currently about 270 members strong.