Excel Report Automation Help
Budget: $10 – $30 AUD
I have a data-heavy spreadsheet that is meant to turn raw dumps into clean, ready-to-share reports. The structure is mostly in place, but the key intermediate formulas. Still need to be written, tested, and streamlined so that the final tabs populate automatically each time I refresh the source data.
Here is what I need from you:
• Ensure the formulas remain dynamic when the underlying tables grow or shrink.
• Provide a brief in-sheet note or comment block explaining the core logic so I can maintain it later.
The focus is firmly on data analysis and report generation, not on visuals or macros, so please stick to native Excel/Google Sheets functions. I will provide a reference spreadsheet and same formulas needs to be used please.
Once your formulas are in place I should be able to drop a fresh data export into the source sheet and watch the summary tabs update instantly, ready for distribution. If that’s in your wheelhouse, let’s get started.
Here is what I need from you:
• Ensure the formulas remain dynamic when the underlying tables grow or shrink.
• Provide a brief in-sheet note or comment block explaining the core logic so I can maintain it later.
The focus is firmly on data analysis and report generation, not on visuals or macros, so please stick to native Excel/Google Sheets functions. I will provide a reference spreadsheet and same formulas needs to be used please.
Once your formulas are in place I should be able to drop a fresh data export into the source sheet and watch the summary tabs update instantly, ready for distribution. If that’s in your wheelhouse, let’s get started.