VBA automation
Custom automation for small business clients: one-click buttons inside the spreadsheets they already use, and old macros rebuilt to run in current Excel.
- Service
- Freelance, since 2022
- Clients
- Small businesses
- Result
- Up to 30% less manual reporting work
Overview
I build VBA automation for small business clients. The work comes in two forms: adding buttons to spreadsheets so a whole process runs in one click, and modernizing old macros written for earlier versions of Excel. Across clients, this has reduced manual reporting workload by up to 30%.
Example: daily reporting
One client had to report results to their database once a day. Staff entered values on one sheet, copied them into a separate calculator sheet, then copied the results again into a simplified reporting sheet. It took over an hour.
I built a button that reads the values from the first sheet, applies the formula the client designated, and writes the results into the reporting sheet that gets submitted. The task became: enter the initial values and click.
Modernizing old macros
Macros built for older versions of Excel can be slow, fragile or unfamiliar to the people maintaining them. I update them for current Excel and keep the workbook feeling the same to the people who use it.