Got a question.

I'm trying to figure out how a data validation drop down list can link to multiple cells/work sheets.



Example: Cell A1 of Sheet1 has a data validation drop down list (of many values) and Cell A1 of Sheet2 also has a data validation drop down list (of many values)

How/What can make/link Cell A1 of Sheet1 editable from Cell A1 of Sheet2 and vice versa?

I would like to make Cell A1 of Sheet1 display the same value to Cell A1 of Sheet2 and vice versa (i'm not talking about linking cells)

Any help or insight would be greatly appreciated!!!