I have 2 drop down lists for the user to select in Dashboard tab.
Based on the selection, information appears on screen (Dashboard).
I am running a pivot table in the background (Customer Filter tab) and a Pivot Chart in Dashboard. (I mean, i could just run a Pivot Chart but anyway).
I would like for the macro to refresh all data whenever a selection is made from either of the lists.
List names:
All_Service_Priority_2
ServiceArea_List2
Any help would be extremely helpful.
Thank you.
Based on the selection, information appears on screen (Dashboard).
I am running a pivot table in the background (Customer Filter tab) and a Pivot Chart in Dashboard. (I mean, i could just run a Pivot Chart but anyway).
I would like for the macro to refresh all data whenever a selection is made from either of the lists.
List names:
All_Service_Priority_2
ServiceArea_List2
Any help would be extremely helpful.
Thank you.