I will automate excel reports with vba macros, formulas and google apps script
Certified QuickBooks ProAdvisor, Bookkeeping, Payroll and Excel
About this Gig
Still repeating the same spreadsheet steps every week? I will build an Excel VBA or Google Sheets automation that turns an agreed manual process into a repeatable workflow.
Projects can include cleaning recurring exports, splitting data into files, updating report tables, repairing formulas, or generating a routine report.
We start with your input file, desired output, and the steps you currently follow. I build the workflow, test it against agreed examples, and deliver the workbook or script with simple operating instructions.
Packages cover one platform and a defined workflow. New data sources, third-party APIs, paid connectors, and major changes to your file structure need separate scope.
I combine spreadsheet work with practical accounting experience, so totals, exceptions, and repeatability receive attention alongside the automation itself.
Send a sample and describe what you want to stop doing manually. We will define the output before development begins.
Platform:
Excel
•
Google Sheets
•
QuickBooks
Development technology:
VBA
•
Google Apps Script
•
Excel
Expertise:
Formatting
•
Pivot tables
•
Formulas
•
Functions
•
Macros
My Portfolio
FAQ
Does this work in both Excel and Google Sheets?
Each package covers one platform. VBA and Apps Script are different implementations; a second platform needs a separate scope.
Will it update automatically?
The agreed workflow may use a button or a supported schedule. Live integrations and credentials are assessed separately.
What files will I receive?
The workbook or Google Sheets solution, editable code where applicable, and instructions for running it.
What support is included?
I correct reproducible defects against the agreed test cases reported within 14 days of delivery. New features or changed inputs are additional work.
Is my data secure, and do you offer support after delivery?
I treat all client data with strict confidentiality – your files are safe with me. After delivery, I provide support to ensure everything works as expected. If you encounter any issues or need minor adjustments, I'm happy to help. My aim is to deliver a smooth experience from start to finish.
1 reviews for this Gig
| (1) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
J 
jonfocus

United States
Ongoing collaborationVery fast and efficient! Thanks for the great work
$50
Price
1 day
Duration
Helpful?
1 reviews for this Gig
| (1) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
J 
jonfocus

United States
Ongoing collaborationVery fast and efficient! Thanks for the great work
$50
Price
1 day
Duration
Helpful?

