I will automate excel reports with vba macros and power query
About this Gig
Still spending hours copying, pasting, and formatting the same Excel report every week? Ill turn it into a one-click process.
I build custom Excel automation using VBA macros and Power Query so your reports refresh, clean, and format themselves.
What I can automate:
Importing and merging data from Excel, CSV, folders, PDFs, databases, and web sources
Cleaning messy data (duplicates, formatting, split/merge columns, errors)
Pivot tables, charts, and dashboards that update automatically
Report formatting, PDF export, and emailing via Outlook
Custom buttons, forms, and macros for repetitive tasks
What you get:
A clean, commented, fully working file
Simple instructions (video walkthrough on higher packages)
Free support after delivery
Strict confidentiality: your data stays private
After placing your order, please message me a sample file (remove sensitive data) and a short list of your current manual steps so I can confirm the scope and recommend the right package.
Works with Excel 2016, 2019, 2021, and Microsoft 365 (Windows).
Platform:
Excel
•
Google Sheets
•
Power BI
Development technology:
VBA
•
Google Apps Script
•
Power Query
Expertise:
Formatting
•
Fixing
•
Pivot tables
•
Formulas
•
Macros
