Hi Everyone
I am not sure how I could do this so I was hoping to get some assistance.
I have an Excel sheet which serves as a data input form. Certain cells are restricted based upon a pull down list generated using the "Validation" option.
I would like to set something up whereby if the user selects a certain choice from a pull down then they are forced to also enter a value in another cell right next to it.
For example, say you are entering information on cars and your first column pull down menu has "Ford, GM, Toyota, Honda" etc. as choices, if a user selects, say Honda, I would like to force the user to enter something in the next column using a pull down menu like "Civic, Accord, CRV, Odyssey" etc. otherwise I'd like to leave it blank.
Any assistance with this would be greatly appreciated! Thanks!!
I am not sure how I could do this so I was hoping to get some assistance.
I have an Excel sheet which serves as a data input form. Certain cells are restricted based upon a pull down list generated using the "Validation" option.
I would like to set something up whereby if the user selects a certain choice from a pull down then they are forced to also enter a value in another cell right next to it.
For example, say you are entering information on cars and your first column pull down menu has "Ford, GM, Toyota, Honda" etc. as choices, if a user selects, say Honda, I would like to force the user to enter something in the next column using a pull down menu like "Civic, Accord, CRV, Odyssey" etc. otherwise I'd like to leave it blank.
Any assistance with this would be greatly appreciated! Thanks!!