Hi experts, I am having a problem figuring this out. I have a data list that I need multiple drop down lists for. I need it so that when you select data in A1, then B1-G1 will all have the appropriate options for A1 listed. The problem is that the data in B1-D1 is all the same list but you choose 2 out of 3 options. E1-G1 is another data set that is pick 2 out of 3. It's like a-la-carte choices.

This on its own is not that bad and I probably could figure out how to do it, but I forgot to mention that I also need the options to disappear once they are selected. This is to avoid doubling an entry.

I should also metion that this is the first worksheet I have made since 2002 in a freshman intro class. So be gentle.