Duplicate, Dependent/Related/Interconnected Data Validation (Drop Down Lists)

Hi,

I have an Excel file with two different visible sheets (dashboards), each with different types of charts, which are pulling from the same data tables on a hidden sheet. I have a data validation drop down list on one of the dashboard sheets, which lists 7 items. Once one of the 7 item is selected, both dashboards update, which is what I want. However, I'd like to be able to have duplicated, related validation drop down lists. So if someone is looking at the first dashboard sheet and they select a new item, when they go to the second dashboard and see that same item, they could on that second dashboard select a new item without having to go back to the first dashboard.

I'd provide an example if I could, but cannot. I've tried searching on the forum for something similar, but most often the topic of dependent data validation is on two different types of drop downs with the second being dependent on the first, whereas I'm looking for two drop downs that are interconnected and can update in sync.

Any advice or help would be much appreciated!

Thank you!

Any problem in using macros?

I can only think of macros. If you can, use the below code in ThisWorkBook code window.
Replace Sheet1 & Sheet2 below with your data validation sheet names and $A$1 with cell address where you have validations respectively.

Please Login or Register  to view this content.