Excel VBA macros & automation, written for you, delivered in 24h.

Need an Excel VBA macro, a report that builds itself, or a button that does the boring part? Send your workbook and what you want to happen. You get a fixed quote within the hour, then a tested, commented macro back, usually within 24 hours.

Fixed price before any work starts. Commented code and a short how-to included.

Get a fixed quote for your macro See prices See sample work

Excel VBA helpMacro developerAutomate Excel reportsUserforms & buttonsFixed priceRush available

What we build

Merge and split sheets or workbooks: combine 50 files into one table, or split one master sheet into a file per customer, region or month.
Automated reports: one click refreshes data, rebuilds the pivots and totals, formats the sheet and saves or exports it as PDF.
Clean imports: macros that take a messy export (extra header rows, text-numbers, merged cells, odd dates) and turn it into a tidy table every time.
Buttons and userforms: data-entry forms with validation, dropdowns and a button on the sheet, so colleagues never touch the formulas.
Outlook mail-merge from Excel: send personalised emails (with attachments if you need them) straight from a worksheet, with a preview or draft step before anything goes out.
Power Query alternative: if Power Query is not available or does not fit, a macro can do the same refresh-and-reshape job. If Power Query is the better tool for your case, we will tell you and build that instead.

Fix or extend an existing macro

Inherited a macro that throws an error, runs slowly or only works on one person's PC? Send it over. We debug it, speed it up, and add comments so the next person can follow it.

Who this is for

Finance and operations staff, bookkeepers, analysts and small business owners who repeat the same Excel steps every week and would rather click one button.

Worked example

An example of our process, not a client story. The scenario is illustrative and any sample data is fictional.

Example job

Input: a master sheet that had to be split into one file per region by hand.

What we did:

Wrote a VBA macro that loops through the regions in the master sheet
Created one workbook per region, keeping formatting and column widths
Added a log of files created and a message if a region has no rows
Tested with blank rows, new regions and an already-open file

Output: A macro-enabled workbook (.xlsm) with the commented VBA code, a button to run it, and a short how-to covering what it does, how to change the output folder, and how to undo it.

Turnaround: Automation jobs are scoped with a fixed quote first, from $299; the delivery time is stated in the quote.

We have no downloadable file for this service yet; see our samples page for other finished work

Excel VBA pricing: fixed, with rush available.

Pick the closest size. We confirm the exact price in your quote before any work starts, and you only pay once you approve it.

Small macro fix

$39 standard

Rush: $69

One broken or slow macro, or a small tweak
A short, simple new routine
Plain-English note on what changed

Order Order rush

Most macro jobs

Standard macro

$199 standard

Rush: $299

A report builder, merge/split tool or import cleaner
Button on the sheet, tested on your file
Commented code and a short how-to

Order Order rush

Bigger automation

$299 from

Rush: $449

Userforms, multi-step workflows, Outlook mail-merge
Several files or sheets tied together
Commented code + a short how-to

Order Order rush

Spreadsheet Desk

$149 per month

Ongoing retainer

A standing desk for your Excel and macro requests
Good if you have a steady stream of small jobs
Ask for details in the quote form

Not sure which fits, or the job is bigger? Send it for a custom fixed quote first. Revisions are included until it does what you asked.

How it works

Send your fileUpload it in the quote form (a copy with sensitive data removed is fine) and describe what the macro should do.

Fixed quote within the hourYou get a price and a delivery time before any work starts. No account needed.

Pay by card through StripeSecure checkout. Work starts when you pay.

Delivered, tested, commentedYou get the workbook (.xlsm) with the macro tested on your file, readable comments in the code and a short how-to. Revisions are included.

Questions

Will it work on Mac?

Basic VBA (formatting, merging, loops, reports, userforms) generally runs on Excel for Mac, but some things do not: ActiveX controls, Windows-only libraries and Outlook automation work differently or not at all on Mac. Tell us which Excel and operating system you use and we will build for it, or say up front if something cannot work there.

Is my data safe? Do you keep my files?

Your files are used only for your job and we do not keep them: they are deleted after delivery on request. If the data is sensitive, send a copy with names or account numbers removed. The structure is all that is needed. The macros we write run on your computer and do not send your data anywhere.

Are revisions included?

Yes. Revisions are included until the macro does what we agreed. If it cannot be done, you get a full refund.

Who writes the code?

Sheetsmith is an AI-powered service: AI tools do the heavy lifting, and every macro is run and checked against your file before delivery. That is why it is fast.

Will my company's macro security settings block it?

Macros need to be enabled to run, and some workplaces restrict them. Tell us if your IT policy limits macros, and we will suggest an alternative such as formulas or Power Query.

What if I'm not sure what I need?

Describe the manual steps you repeat. We will tell you honestly in the quote whether a macro, formulas or Power Query is the best fit.

Get your fixed quote

Upload your file and say what you want automated. You'll have a fixed price within the hour, and you pay nothing until you approve it.

Open the quote form

Prefer email?

Email for a quote

chrisgrant2019+sheetsmith@gmail.com