D
DocBrown
I am using a drop-down list for data validation in a column. Can I make the
drop-down list in another column dependent on the contents of the first
column?
Example:
Col A has a list defined:
Fruit
Vegetable
If the user selects fruit, then in Column B the list is:
Apple
pear
If the user selects Vegetable, then the column B list is:
Peas
Carrots
thanks
John
drop-down list in another column dependent on the contents of the first
column?
Example:
Col A has a list defined:
Fruit
Vegetable
If the user selects fruit, then in Column B the list is:
Apple
pear
If the user selects Vegetable, then the column B list is:
Peas
Carrots
thanks
John