I love Excel. My wife is an accountant working toward her CPA. During busy season, I'd watch her navigate the same repetitive workflows that every tax professional deals with — updating period-end dates across dozens of tabs, tying out trial balances, hunting through sprawling workbooks. The kind of work that eats hours and adds no value.
So I started writing macros to take those tasks off her plate. Then for her colleagues. Then it became clear that the same problems exist in every tax practice — and the people dealing with them shouldn't need someone technical at home to help.
Every macro on this site has been tested on real workpapers by a real accountant who catches every edge case before I publish. I write the code; she runs it against actual client data. What you get is the working version.
If there's a repetitive task in your tax workflow that you wish you could automate, I want to hear about it. The best macros on this site came from reader suggestions — real problems from real practitioners.
Reach out at hello@excelmacroguy.com .
Yes, "Excel Macro Guy" is a bit tongue-in-cheek. No, you don't have to be a guy to use these macros. The macros don't check.