Why I Automate Everything With VBA

Most people think of Excel as a place to type numbers. I think of it as a platform. Somewhere along the way, managing a massive product catalog, I got tired of doing the same manual steps over and over — pulling a fiscal date range, reformatting a report, cross-checking one sheet against another — and started building macros to do it instead.

That habit turned into real tooling: fiscal calendar generators built on a proper 4-4-5 week pattern, pipeline trend dashboards that update themselves, formulas that reach across sheets dynamically instead of breaking every time a tab gets renamed. None of it is flashy. All of it saves hours.

VBA gets a reputation as outdated, but for this kind of work — fast, spreadsheet-native automation that a non-engineer can maintain — it's still hard to beat. I'll be sharing some of the actual techniques here as I go.