Archive: Excel report adjustment

Budget By arrangement

Posted: 5 years ago

Closed

Description: Hi,

I need to make template for sales reporting (PIVOT+DASHBOARD, maybe comparison with plan - two PIVOTs)
Original raw sheet is export from ERP and it's not formatted. It will be added with new rows (new data) every once in a while (weekly, monthly, per request). That sheet needs formatting (or to be cross-linked to formatted table) in order to be pivoted and analyzed.
An extra would be few dashboards and comparison with planed values (other pivot table)
In attach. is example table so I need estimated value for such work/project.
Budget is very limited so just few formulas maybe VBA (for template formatting) would be enough for me to finish work. Any advice is wellcome.

Thank you!
Working conditions:
Fixed Price
Not Sure
Skills:
vba,dashboard design,microsoft excel,microsoft excel pivot tables