Hello all! I hope to find you well.
I've been looking for ways of displaying only certain checkboxes when a given condition is met, however, I haven't find anything.
In my task, I have a Department Code (cell D9 of Sheet1) that can assume the value 130, 131, 132, 138, 182, 184 or 187.
Then, from A37 to A40, I have 4 checkboxes (product offered).
This excel will work like a simulator that everyone can use. And, for example, once a person writes 130 in D9, I would like her/him to see and be able to select only the checboxex a,c,d. Another example: when a person selects from the dropdown list "138", she/he should be only able to see and to select the checkboxes a,b. And so on (you can see the matching in sheet "Department and Products")
Any ideas of how I should proceed?
Thank you very much!
Bookmarks