Job:
Add macros and formulas to Excel Spreadsheet so that the dashboard updates automatically when drop down menu selects new date range.
Tasks:
1. Add four columns of formulas linked to worksheet data to be created:
a. Current month
b. Week on week variance ie. Current month - Last month (+/-)
c. Last 4 weeks average ie. Curent month + Last 3 months / 4
d. Last 12 weeks average ie. Current month + 11 months / 12
2. Add macro to charts up so they update automatically
Attached is an example of how it works including formulas. I would like this functionality copied on to the Dashboard.
I am an excel developer. I am expert in Excel both excel standard and Vba coding. I work with excel more than 10 years.I have viewed both of your attachments, you can do without macro, but I can do both ways. More in PM, please.
$40 AUD en 2 días
4,7 (13 comentarios)
3,8
3,8
8 freelancers están ofertando un promedio de $84 AUD por este trabajo
I have 20 years experience in excel, the last 10 of which included writing complex macros and improving automation.
Please see my profile for more background.
Thank you,
Andrew Stanhope