I have an excel spreadsheet with two tabs- a report tab and a data tab.
The report tab has two dropdown boxes (allowing the user to select a specific week, and then a specific item).
I then have two columns of data in this report tab:
column 1 is my 3 digit zip
column 2 is my average price of the week/item selected in each of the dropdowns (using averageifs).
I would like to be able to plot these average prices on a MapPoint map within this same spreadsheet, that would also update anytime the dropdowns were changed.
Suggestions?
The report tab has two dropdown boxes (allowing the user to select a specific week, and then a specific item).
I then have two columns of data in this report tab:
column 1 is my 3 digit zip
column 2 is my average price of the week/item selected in each of the dropdowns (using averageifs).
I would like to be able to plot these average prices on a MapPoint map within this same spreadsheet, that would also update anytime the dropdowns were changed.
Suggestions?
