I'm trying to figure out the best approach for this task;
- user selects yes or no from a dropdown (or a check box would be nicer visually)
- if user selects no, nothing happens
- if user selects yes, a further 4 "questions" need answering, the possible answers should be from dropdowns not free text
- the results of these 4 questions should appear in 4 cells to the right somewhere (location not that important)
I started with data validation, then a check box but I cant figure out how to address the further 4 questions/responses.
Is this going to have to be a VBA solution?
TIA
- user selects yes or no from a dropdown (or a check box would be nicer visually)
- if user selects no, nothing happens
- if user selects yes, a further 4 "questions" need answering, the possible answers should be from dropdowns not free text
- the results of these 4 questions should appear in 4 cells to the right somewhere (location not that important)
I started with data validation, then a check box but I cant figure out how to address the further 4 questions/responses.
Is this going to have to be a VBA solution?
TIA