I have a dropdown list in a cell on, say, sheet1. Then for example, on sheet2 I need the same drop down list, BUT if a value is selected in the dropdown list on sheet1, when I switch to sheet2, I want the value selected to populate the same cell that has the dropdown.
Conversely, if a value is...