Is it possible to make a cell always fill with a certain item from a dropdown list?
Example:
If Numbers is selected, the possible values are One, Two and Three (in that order). A2 fills with One, B2 with Two, and C2 with Three.
If Words is selected, the possible values are Apple, Banana and Carrot (in that order). A2 fills with Apple, B2 with Banana, and C2 with Carrot.
Bookmarks