The monthly report that takes a day of copy-paste, the file merge nobody wants to own, the sheet that breaks when someone sneezes — I automate it with VBA, Power Query and Google Apps Script. The same toolkit once collected and validated submissions from 345 institutions, catching 20,000+ bogus records automatically.
What I Offer
Custom macros that turn hours of repetitive Excel work into one click: merging files, formatting reports, reconciliations, data entry forms and email-out of finished workbooks.
Self-refreshing Excel reports that pull straight from databases, folders of files or APIs — press Refresh and the month-end pack rebuilds itself, no copy-paste, no broken links.
Automation across Google Workspace: forms feeding validated sheets, scheduled imports, automatic emails and dashboards — the setup I used to collect and validate data from 345 institutions.
The inherited monster: 40 tabs, volatile formulas, ten-minute opens and one person who understood it left last year. I audit it, fix it, speed it up and document it.
Process
Describe the manual process (or send a sample workbook with dummy data). I’ll confirm the best approach — VBA, Power Query or Apps Script — with a fixed quote, usually same day.
Built with proper error handling, input validation and logging — so when something unexpected arrives, the automation tells you instead of silently producing wrong numbers.
You get the working solution, commented code, a plain-English guide and a walkthrough call — plus 30 days of free fixes if anything misbehaves.
Why Me
Built the Apps Script and VBA system that collected and validated data from 345 institutions for a government department — flagging 20,000+ bogus records automatically.
Validation, error handling and logging in every build — automation that fails loudly and safely, never one that quietly emails the wrong numbers to your boss.
Sometimes the answer is Power Query, not a macro — and sometimes it’s a proper database. As a data engineer I’ll tell you which, and can build the upgrade when you’re ready.
Most single-workflow automations are delivered within a week at a price agreed upfront — with 30 days of free fixes included.
Questions