Browse categories
Explore
Fiverr Pro
English
$
USD
I will write complex excel vba macros, google sheets scripts, and advanced formulas
Excel VBA and Google Sheets Automation Expert
I specialize in turning messy spreadsheets into automated, efficient systems. With extensive experience in Excel VBA, Google Apps Script, and complex data logic, I help businesses eliminate manual dat...
About this Gig
Stop wasting hours on manual data entry and broken spreadsheets.
I build custom automations, complex formulas, and scripts that turn messy data into instant, error-free results. Whether you need a dynamic dashboard, a Google Apps Script to connect your sheets to other tools, or a VBA macro to automate your daily reporting, I will deliver clean, bug-free solutions fast.
What I can do for you:
Advanced Formulas: (XLOOKUP, INDEX/MATCH, ARRAYFORMULA, complex nested logic)
Custom VBA Macros: Automate repetitive Excel tasks with a single click.
Google Apps Script: Custom functions and automated workflows for Google Sheets.
Data Cleaning: Formatting and organizing massive, messy datasets.
Fixing Broken Sheets: Debugging errors and optimizing slow spreadsheets.
Note: Please send me a message with your exact requirements and a sample of your sheet (dummy data is fine) before placing an order so we can confirm the scope!
Platform:
Excel
•
Google Sheets
•
VBA
Development technology:
VBA
•
Google Apps Script
•
Excel
Expertise:
Fixing
•
Formulas
•
Macros
•
Dashboard
•
Cleaning
FAQ
Do I need to know how to code to use your delivery?
Not at all. I will provide you with the exact formula to paste, or step-by-step instructions (with screenshots if needed) on exactly where to click to run the macro or script. It takes seconds.
What if I have a massive dataset? (100,000+ rows)
Advanced Google Apps Script or VBA handles large datasets much better than standard formulas. Please message me first so I can assess the most efficient way to process it without crashing your workbook.
Do you sign NDAs for sensitive business data?
Yes. However, I always recommend replacing sensitive client names or financial figures with dummy data (e.g., "Client A", "$100") before sending the sheet. The logic and code will work exactly the same on your real data.
Can you fix a broken script someone else wrote?
Yes. Please send me the script and a description of the error message you are receiving. I will debug and rewrite it to function correctly.
