Excel Report Automation Specialist
Budget: ₹1,500 – ₹12,500 INR
I need my recurring reports to build themselves. Right now all of the source data already lives in several Excel spreadsheets; what’s missing is a robust routine—ideally driven by VBA, Power Query, or a combination of formulas and pivot tables—that pulls the data together and spits out a finished report at the press of a button.
Here’s what success looks like to me:
• One master workbook or template that automatically imports the latest data from the designated source sheets.
• A refreshable, well-formatted summary tab that updates charts, tables, and key metrics without manual intervention.
• Clear, commented code/macros so future tweaks are straightforward.
• A brief hand-off note (or short screen-recording) showing exactly how to run and maintain the automation.
If you have a track record of building similar Excel-based reporting systems, especially with VBA or Power Query, I’d like to get this moving quickly.
More important is the implementation of formulae's so the results populate automatically when input
Here’s what success looks like to me:
• One master workbook or template that automatically imports the latest data from the designated source sheets.
• A refreshable, well-formatted summary tab that updates charts, tables, and key metrics without manual intervention.
• Clear, commented code/macros so future tweaks are straightforward.
• A brief hand-off note (or short screen-recording) showing exactly how to run and maintain the automation.
If you have a track record of building similar Excel-based reporting systems, especially with VBA or Power Query, I’d like to get this moving quickly.
More important is the implementation of formulae's so the results populate automatically when input