Hi everyone!
I am hoping that this is possible.....I'd like to set up drop down menus where the options vary, depending on what is input into a previous cell. For instance, if column A has a drop down menu that lists "fruit, vegetable, dairy, meat", then column B has a drop down menu that delves deeper, but only shows choices based on what you chose in Column A. So, column B menu would list apples and oranges as options if you chose fruit, and beans and potatoes if you chose vegetable. Is this possible?
Thanks for your help!
I am hoping that this is possible.....I'd like to set up drop down menus where the options vary, depending on what is input into a previous cell. For instance, if column A has a drop down menu that lists "fruit, vegetable, dairy, meat", then column B has a drop down menu that delves deeper, but only shows choices based on what you chose in Column A. So, column B menu would list apples and oranges as options if you chose fruit, and beans and potatoes if you chose vegetable. Is this possible?
Thanks for your help!
