We build Excel tools: macros that do the repetitive steps, workbooks that combine many files into one report, and templates with the formulas and checks already in place. Built so the person who uses it every day can understand it.
Tell us what you needSee typical projectsYou see it working at every milestone, not a status report.
What we hear from businesses before a project like this starts.
The requests that come up most often for this kind of work, and what each one takes to work properly.
A workbook that opens on a summary sheet, one row per store or branch, followed by the group total.
Power Query steps that clean and reshape the export, so refreshing the report is one click.
VBA that does the copy, format, filter and save steps your team does by hand today.
Locked formulas, input cells that check what is typed, and clear instructions on the sheet.
Inventory, orders, songs, projects or cash, with the totals and alerts you need.
Existing VBA read, documented and repaired, especially after an Office update.
Tools that come up most: Excel, VBA, Power Query, Power Pivot, pivot tables, MS Access, CSV exports, Google Sheets, Power BI.
Concrete pieces, each one something you can open and check when it's done.
Buttons that run the repetitive steps: import, clean, format, split, email and save.
VBA, Excel object modelRepeatable clean-up and reshaping of exports, refreshed with one click.
Power Query, MMany workbooks or sheets combined into one summary, with the group total.
Power Query, VBASummary sheets, pivot tables and charts that update when the data does.
Pivot tables, Power Pivot, chartsProtected templates with validation, so the numbers coming in are right.
Data validation, protection, named rangesExisting Access databases and macros documented, repaired and tidied.
MS Access, VBAExample packages to show the shape of the work. These are examples, not past clients; yours gets its own written scope.
Example package
One workbook that pulls every store or branch file into a single summary with a group total.
You get
Example package
A raw system export cleaned and turned into the report your managers read.
You get
Example package
The steps someone repeats every day or week, done by a macro.
You get
Example package
A critical workbook or macro set read, repaired and explained.
You get
Granite River Fabrication built every quote by copying an old spreadsheet, which led to stale material prices and missed margins. We built a macro-enabled quoting workbook with its own Quoting tab on the ribbon. Estimators add lines from a form that pulls rates from the current price list, a margin check blocks quotes below the floor, and one click exports a branded PDF, emails it to the customer and logs the quote. Accepted quotes can be sent to QuickBooks as estimates.
Excel VBA, custom ribbon XML, Power Query, Outlook automation, QuickBooks Online API
A working example we built to show this kind of work. It is a demonstration, not a client project.
Sample build
One-button VBA macro that turns an Invoices sheet into a formatted accounts-receivable aging report by customer (Current, 1-30, 31-60, 61-90, 90+), with totals and 60+-day balances highlighted.
Excel VBA, openpyxl, Python, Docker
About the screenshot: The tool's output sheet: the aging report the macro produces from sample invoices.
The habits that keep this kind of project from going wrong.
We talk to whoever opens the workbook every day, and design the sheet around what they do.
If a formula or Power Query step does the job, we use that rather than VBA, because more people can follow it.
Totals that must match, files that must be present, and inputs that must be numbers are checked and flagged.
No locked VBA projects or hidden sheets you can't open. You get the passwords, if any.
A written scope first, then working progress you can check, then a proper handover.
Tell us what you need in your own words, and which tools you already use. A few lines is plenty to start.
We reply with a short written scope: what gets built, what is out of scope, which accounts we need, and how we'll both know it works. You know what you're getting before work begins.
The work is split into milestones. At each one you see it working in your own account and sign it off before we go on.
You get the working system, its documentation and a walkthrough. If anything we built breaks in the next 30 days, we fix it at no charge.
Pushbuild has built software for businesses since 2010, for more than 40 clients. Every project is led by a former public-company CTO, from Groton, Massachusetts. See products we've built.
Microsoft 365 and recent desktop versions on Windows. Mac Excel and Excel on the web do not run all VBA, so we tell you in the scope if that matters.
Yes. Send a copy with any sensitive data removed or replaced, and we work on that.
You do. There are no locked projects or licence keys; you get everything.
No. We build tools that do the work. If you need a one-off batch typed in, a data entry service will be cheaper and we will say so.
Most Excel tools take a few days to two weeks from the signed scope.
In the 30 days after handover we fix anything we built at no charge. After that, further work is scoped the same way and agreed with you before we start.
Email a few lines about what you want and which tools you use, or call. We reply with questions or a written scope.
hello@pushbuild.com