I will create excel formulas vba macros and google sheets
About this Gig
Stuck on a formula, or doing the same Excel task by hand every week? I build formulas, VBA macros and Google Sheets automations that do the work for you.
What I can do:
- Fix broken formulas and #N/A, #REF, #VALUE errors
- XLOOKUP, VLOOKUP, INDEX MATCH, SUMIFS, COUNTIFS, IF, FILTER, QUERY, ARRAYFORMULA
- VBA macros: one-click buttons that format, merge, split or email reports
- Google Apps Script: auto-fill sheets, send emails, import data, scheduled triggers
- Dashboards, dropdowns, conditional formatting and charts
- Trackers for sales, inventory, payments, budgets and attendance
How it works:
1. Send your file (or a copy with sample data) and describe the result you want
2. I build and test it on your data
3. You get the working file plus short notes on how it works
Every formula and macro is unlocked and commented so you can edit it later. Not sure which package fits? Message me with a screenshot and I'll tell you before you order.
Platform:
Excel
•
Google Sheets
Development technology:
VBA
•
Google Apps Script
•
Python
Expertise:
Fixing
•
Formulas
•
Functions
•
Macros
•
Dashboard
FAQ
Is my data safe?
Your file is used only to complete your order. It's never shared or resold.
Excel or Google Sheets: which do you work in?
Both. Excel (Windows or Mac, Microsoft 365, 2016 and later) with formulas and VBA, and Google Sheets with formulas and Apps Script. Tell me which version you use and I'll build for it.
Can you fix a formula or macro someone else built?
Yes. Send the file and tell me what it should do. I'll find what's broken, fix it, and explain the cause so it doesn't happen again. Small fixes fit the Basic package.

