I will automate your excel reports and dashboards with vba macros


About this gig
Rebuilding the same Excel report every week? I build VBA macros that do it with one click: refresh your data, update the charts and dashboard, and export the finished report as PDF or Excel.
I work in finance, where the same reports get rebuilt every month, so I know which steps are worth automating.
What I automate:
- Report building: consolidate sheets and files, refresh pivots and charts
- Dashboards with buttons, dropdowns, and one-click refresh
- Data entry forms with validation, saving records to a table
- PDF export and email-ready reports
- Cleanup and formatting of messy exports
What you get:
- A macro-enabled .xlsm file with clean, commented code (no password locks)
- A short how-to sheet, including how to unblock macros on your PC
- Answers to your questions after delivery
Built for desktop Excel (Windows preferred; tell me if you use Mac). Macros do not run in Excel for the web.
How it works: describe the manual steps you repeat today and send a sample file. I confirm scope and price, then deliver a draft to test.
Not sure your task fits? Message me a short description, and I will tell you what is possible.
Get to know Hanzala
Finance and Data Analyst, Power BI, Excel Expert , Data Visualization
- FromPakistan
- Member sinceNov 2020
- Last delivery4 months
Languages
Urdu, English
My Portfolio
Other Data Visualization Services I Offer
8 reviews for this Gig
| (8) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
A aran666

Saudi Arabia
Ongoing collaborationGreat Delivery definitely we will work again.
$100-$200
Price
9 days
Duration
Helpful?H hassy00

United States
Ongoing collaborationHe is exceptional and above expectations.
$50
Price
1 day
Duration
Helpful?K knarichj

United States
Ongoing collaborationHanzala did a great job. All I supplied was the data, and created a full set of dashboards. Excellent communication and super fast turnaround. I would definitely use his service again. Joe (NY)
$100-$200
Price
5 days
Duration
H 
Seller's Response
Helpful?J josh_100

United States
Very helpful and delivered work as described. Always communicated on time!
$50
Price
Helpful?A akinolaoyegoke

United Kingdom
Very responsive. Great job.
$50
Price
Helpful?
8 reviews for this Gig
| (8) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
A aran666

Saudi Arabia
Ongoing collaborationGreat Delivery definitely we will work again.
$100-$200
Price
9 days
Duration
Helpful?H hassy00

United States
Ongoing collaborationHe is exceptional and above expectations.
$50
Price
1 day
Duration
Helpful?K knarichj

United States
Ongoing collaborationHanzala did a great job. All I supplied was the data, and created a full set of dashboards. Excellent communication and super fast turnaround. I would definitely use his service again. Joe (NY)
$100-$200
Price
5 days
Duration
H 
Seller's Response
Helpful?J josh_100

United States
Very helpful and delivered work as described. Always communicated on time!
$50
Price
Helpful?A akinolaoyegoke

United Kingdom
Very responsive. Great job.
$50
Price
Helpful?

