Add Macros to Excel Spreadsheet / Dashboard


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.

Квалификация: Excel

Показать больше dashboard macro excel, macro excel dashboard, excel macro dashboard, excel macros dashboard, macro dashboard excel, excel dashboard macros, dashboard excel macros, excel dashboard macro, excel dashboard macro works, automatically update dashboard excel, macros excel dashboard, macros dashboard excel, macro dashboard, excel macros update dashboard date, excel dashboard drop menu, macro update excel dashboard, job spreadsheet, how excel works, excel macro how to, dashboard functionality, 12 month spreadsheet, dashboard com macros excel, spreadsheet dashboard date, add macros spreadsheet, variance

О работодателе:
( 1 отзыв ) Sydney, Australia

ID проекта: #1491754



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 P Больше

$40 AUD за 2 дней(-я)
(13 отзывов(-а))

8 фрилансеров(-а) в среднем готовы выполнить эту работу за $84


Consider it done. Check your PM.

$150 AUD за 3 дней(-я)
(49 отзывов(-а))

I can provide the required macros in Excel VBA.

$45 AUD за 3 дней(-я)
(30 отзывов(-а))

Please see my PM.

$50 AUD за 5 дней(-я)
(4 отзывов(-а))

I can provide you with the macros needed. Regards, Mike

$130 AUD за 15 дней(-я)
(9 отзывов(-а))

Sir, I have good experience. Your topic is easy!

$40 AUD за 4 дней(-я)
(2 отзывов(-а))

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).

$120 AUD за 3 дней(-я)
(0 отзывов(-а))

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

$100 AUD за 2 дней(-я)
(0 отзывов(-а))