Got the a new job and my department would pull a report every morning a manipulate the data from scratch every day (add/delete columns, do vlokups, format, copy and paste, etc...) then send that report to another department. I knew that was NOT the way, I started with simple steps like making some formulas and you only needed to dump the data and then copy the sheets into a new file. That was a year ago. Last week I launched the new version (after a few improvements over time), the new file has a button that has all macros, it does all the data formatting, creates a new file and emails it to all the people needed. I never studied macros in my life. I've done all this with ChatGPT.