Need help with drop down on one page that updates a pivot table on another

ajmarti82

New member
Joined
Mar 16, 2016
Messages
1
Reaction score
0
Points
0
Basically I have a dashboard. Right now B1 is =Pvts!B2 which is the week on the pivot table. I am looking for a way to create a drop down so you can change the week on the dashboard and the pivot table with change to that week as well. Any help would be greatly appreciated! Thank you
 
Back
Top