Note: The other languages of the website are Google-translated. Back to English
Log in  \/ 
x
or
x
Register  \/ 
x

or

unansweredDependent data validation?

More
3 months 3 weeks ago - 3 months 3 weeks ago #3459 by SituFangs
Dependent data validation? was created by SituFangs
How can I create data validation in one cell that is dependent on what is entered in a different call?Example: In A1 I have a data validation drawing from a list of school subjects. The user can select one of the subjects from the dropdown menu. The dropdown menu in B1 will vary depending on what was selected in A1. If A1 has "Mathematics," B1 will provide options of various math classes. If A1 has "Public Speaking", B1 will provide options of various public speaking classes. <!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--> 10.0.0.0.1 - 10.0.0.1 Admin Login
Last edit: 3 months 3 weeks ago by SituFangs.

Please Log in or Create an account to join the conversation.

Moderators: Excelfans