I have a data validation list with a number of options in it (for the purpose of this question will consider it populated with "option a", "option b", "option c", and "option d"). On another worksheet called "Lists" I have a set of data that looks something like this:
Option 1 Option 1 Q Drive Option 1 SC Drive A Drive Option 2 Option 2 Q Drive Option 2 SC Drive A Drive, C Drive, D Drive Option 3 Option 3 Q Drive Option 3 SC Drive Option 4 Option 4 Q Drive Option 4 SC Drive B Drive, C Drive
What I would like is to have an area where when I select an option in the list it populates said area with all the options (if any) from the 4th column as checkboxes to select from. The number of checkboxes to select from can change from option to option but shouldn't be greater than about 10 checkboxes. Note that I can re-organize the above table if necessary (it's structure isn't set in stone and can be changed if needed).
Bookmarks