Excel/VBA Automation & Web Development

I turn repetitive work into something automatic.

Sole developer, 11 years building and maintaining business-critical spreadsheet and web tools — now taking on Excel/VBA automation and small web builds as a freelancer.

Eleven years of ownership, not just output.

5 yrs
Sole developer & maintainer of a business-critical HTML/JS/CSS application
20K+
Orders processed monthly by the systems I built
$500K+
In inventory managed through the tools I maintained

For 5 years, I was the sole developer and maintainer of a custom HTML/JavaScript/CSS application used daily by an 8-person team — preceded by 6 years designing and running the Excel-based system it replaced. I own the full lifecycle: requirements, development, testing, deployment, and ongoing iteration. I'd rather spend an extra hour catching an edge case than ship something that breaks under real use.

Two problems, one instinct: eliminate the busywork.

01

Excel/VBA Macros

Custom macros that automate repetitive spreadsheet tasks — from data cleanup to one-click report generation.

02

Excel Dashboards & Templates

Structured, formula-driven workbooks that turn raw data into something a client can actually read.

03

Simple Business Websites

Fast, no-framework HTML/CSS/JS sites — no bloat, no unnecessary dependencies, built to load instantly.

04

Small Web Tools & Calculators

Embeddable, interactive tools — quote calculators, form logic, live data processing — for an existing site.

Three demos, built to show the range.

Screenshot of the automated invoice generator, showing a populated invoice for Dana Whitfield with a $1,155 total due.

Automated Invoice Generator

A client hands over a raw, messy order spreadsheet. Selecting a customer from a dropdown auto-populates the entire invoice — contact info, line items, subtotal, tax, and total — via INDEX/MATCH/COUNTIF formulas. A companion VBA macro adds one-click PDF export.

Excel Macros VBA Task Automation

Windows may block the macro after downloading — right-click the file → Properties → check "Unblock" → OK, then reopen.

Screenshot of the Cascade Moving Co. instant quote calculator, showing a live price estimate of $743 to $924.

Instant Quote Calculator

A moving company needed a quote calculator customers could use themselves, instead of waiting on a callback. Selecting home size, distance, and add-ons updates the price range, crew size, and hours live — pure HTML/CSS/JS, no backend.

HTML/CSS/JS Responsive Design Form Logic
Screenshot of the order report tool, showing total revenue, order count, average order value, a daily revenue chart, and top customers and products.

CSV Order Cleanup & Report Tool

A client's order export is never clean — duplicate rows, inconsistent casing, missing fields. Drop the CSV in and it dedupes, normalizes, and flags incomplete rows for review, then generates a revenue summary, chart, and top customers/products — entirely in the browser, no data ever leaves the page.

HTML/CSS/JS Data Cleaning Task Automation

What I actually work with.

Excel Macros Visual Basic for Applications Task Automation Spreadsheet Automation Microsoft Excel OLE Automation HTML CSS JavaScript Web Development Front-End Development Responsive Design