I have attached a file that I am working on ...
I am on the tabs DashBoards and Trends ...
in the upper left corner on both tabs there are 3 Option boxes for data: Week #, Month and Quarter #
I want to be able to change the box on EITHER tab and have both of them equal each other (if that makes sense) ... so, I want to be able to make a change to Week # on the DashBoards tab and have that change simultaneously on the Trends tab ... and vice versa .. if I make a change on the Trends tab, ... I want that change to be made simultaneously on the DashBoards tab ...
I'm not sure if it matters but all three of the selection boxes are tied to data validation which is on a 3rd tab: Data Set-Up ... if that matters ...
thank you for helping ...
Bookmarks