Add macros and formulas to Excel Spreadsheet so that the dashboard updates automatically when drop down menu selects new date range.
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.
8 фрилансеров(-а) подали заявки на эту работу; средняя заявка - $84
This is very interesting, and the Excel is well built. I'd like very much to do it. You can check my references on Elance (P. Vaz, from portugal).
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