I will write excel formulas, vba macros or google apps script for your sheet
About this Gig
A formula that returns #N/A, a lookup that breaks every month, a task you click through by hand every Monday. I write and fix the formulas, macros and scripts that make your spreadsheet do the work.
What I can do:
- XLOOKUP, INDEX/MATCH, SUMIFS, array and date formulas, written or fixed
- VBA macros for Excel, Google Apps Script for Google Sheets
- Buttons, menus and simple forms that run the job in one click
- Automatic emails, reports or file exports from your sheet
You get the working file and a short plain-English note on how it works, so you are not stuck with a black box.
How it works: message me your file (or a copy with dummy data) and describe what should happen. I confirm the scope and price, then build, test on your data and hand it over.
I build with AI coding tools and test every formula and script on your sheet before delivery.
Not included: hacking locked or protected files, or work that needs your passwords.
Platform:
Excel
•
Google Sheets
Development technology:
VBA
•
Google Apps Script
•
Python
Expertise:
Fixing
•
Formulas
•
Functions
•
Macros
•
Dashboard
