I will automate excel tasks with vba macros
Senior Business Analyst , 20ye
Level 2
Has met high performance criteria and has a proven track record for meeting client expectations.
About this Gig
Stop wasting hours on manual Excel work.
I build Excel and VBA tools that turn repetitive tasks into one click: automated reports, interactive dashboards, data cleaning, ERP data extraction, and custom macros.
With 20+ years as a Senior Business Analyst, I don't just write code. I first understand your process, then build the simplest tool that solves it. That's why every one of my reviews is 5 stars.
What I can build for you:
- Custom VBA macros and automation (one-click reports, batch processing)
- Interactive dashboards with charts, KPIs and slicers
- Advanced formulas (XLOOKUP, INDEX/MATCH, dynamic arrays)
- UserForms, buttons, dropdowns and data entry interfaces
- Data cleaning: duplicates, formatting, validation
- Pivot tables and automated reporting
- Power Query connections to external data sources
How it works:
- Message me with a short description of your file and what you want to automate
- I confirm scope, price and delivery time
- You receive a working file, tested, with source code and a short usage guide
Also available for Google Sheets (Apps Script) and recurring support.
Note: VBA macros require Excel for Windows. Mac and Google Sheets solutions available on request.
Platform:
Excel
•
Google Sheets
•
Microsoft Office
Development technology:
VBA
•
Google Apps Script
•
Power Query
Expertise:
Formatting
•
Fixing
•
Forms
•
Pivot tables
•
Formulas
FAQ
Does this work on Mac or Google Sheets?
VBA macros require Excel for Windows. For Mac users I can build formula-based solutions or Google Sheets tools with Apps Script, which work on any system. Just tell me your setup in the first message and I'll recommend the right approach.
Do I get the source code?
Yes, always. The code is delivered unlocked and commented, so you (or any developer) can read it, modify it and maintain it. You fully own what I build for you.
Can you handle confidential data? Do you sign NDAs?
Yes. I treat all client files as confidential by default and I'm happy to sign your NDA before you share anything. If you prefer, you can also send an anonymized sample file with fake data and I'll build the solution on that.
What do you need from me to start?
Two things: a sample of your file (even with fake data) and a short description of the result you want, e.g. "I paste raw data here and want a clean report with one click". From that I'll confirm scope, price and delivery time.
My file is slow / broken / full of errors. Can you fix it?
Yes, fixing and optimizing existing files is a big part of my work: broken formulas, slow workbooks, corrupted macros, messy data. Send me the file and I'll tell you what's wrong and how long the fix will take.
Will I be able to use the tool without technical knowledge?
That's the goal. Everything I build runs from simple buttons, with clear messages and basic error handling. On request I can include a short usage guide or a video walkthrough so your whole team can use it.
Do you offer support after delivery?
Yes. Bug fixes on delivered work are always free. For changes or new features after the order is complete, I offer follow-up orders or recurring support. Many of my clients come back for exactly this.
49 reviews for this Gig
| (49) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
G 
gianl1998

Italy
Lavoro impeccabile per un file di gestione interna di un'agenzia di rappresentanza!
$200-$400
Price
7 days
Duration
Helpful?S 
sestinif

Italy
Veloce e affidabile
Up to $50
Price
5 days
Duration
Helpful?M 
mirkobologna

Italy
Ottima esperienza, lo consiglio
Up to $50
Price
1 day
Duration
Helpful?M markus_franek1
Repeat Client

Austria
Francesco helped me with a project in Excel, he delivers fast and had found the errors in the sheet. I really like to work with him because he understand the hole problem and delivers solutions fast in no time. 10/10 I really recommend him and would choose him anytime again.
Up to $50
Price
1 day
Duration
Helpful?A 
anisabala

Italy
Sono stata molto contenta, perchè ha capito le mie necessità subito, ed è stato velocissimo ad eseguire il lavoro.
Up to $50
Price
1 day
Duration
F 
Seller's Response
Helpful?
49 reviews for this Gig
| (49) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
G 
gianl1998

Italy
Lavoro impeccabile per un file di gestione interna di un'agenzia di rappresentanza!
$200-$400
Price
7 days
Duration
Helpful?S 
sestinif

Italy
Veloce e affidabile
Up to $50
Price
5 days
Duration
Helpful?M 
mirkobologna

Italy
Ottima esperienza, lo consiglio
Up to $50
Price
1 day
Duration
Helpful?M markus_franek1
Repeat Client

Austria
Francesco helped me with a project in Excel, he delivers fast and had found the errors in the sheet. I really like to work with him because he understand the hole problem and delivers solutions fast in no time. 10/10 I really recommend him and would choose him anytime again.
Up to $50
Price
1 day
Duration
Helpful?A 
anisabala

Italy
Sono stata molto contenta, perchè ha capito le mie necessità subito, ed è stato velocissimo ad eseguire il lavoro.
Up to $50
Price
1 day
Duration
F 
Seller's Response
Helpful?

