How to show the same value on each drop down list on every sheet
I have drop down list (by data validation list feature) on sheet # 1, and also have the same drop down list on sheet #2, I want when I select value from this drop down list on sheet 1, the value of the drop down list on sheet 2 will be change automatically and vice versa
Bookmarks