Multiple drop down lists from same data list.

[helyes]

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.

[teylyn]

Hello,

you have not picked an easy task to get back into spreadsheet design.

Sounds like you want to create dependent data validation. Here is a tutorial

http://www.contextures.com/xlDataVal02.html

And here is how to hide previously used items:

http://www.contextures.com/xlDataVal03.html

cheers,