List based on selection in previous cell?

[karlf]

I would like to limit the list selections in subsequent cells as selections are made. Say I start with a list of numbers from 1-10 in cell A1, if my first selection is 8 my selection set in B1 needs to be 1,2,3,4,5,6,7,9,10. If I then select 3, the selection set in C1 needs to be 1,2,4,5,6,7,9,10, and so on until the list is totally eliminated.

Thank you in advance for your help.

Karl

 

[Dreamboat]

You'll need to set up a table of the variables elsewhere. Another sheet is great.

Column A should have the selected numbers.
Column B through whatever should contain the first of the other selections. C the second, and so on.

Then, create a data-validation for the dropdown in A (and all the rest of them), with vlookups.

Maybe.
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word

 

[karlf]

If I understand correctly, the members in the second set(column B) are predetermined. This is not the case. Your second selection set needs to be based on what what was selected from your first. These values aren't known until the selection is made. The second selection includes everything from the first set minus the value selected the first time. Third selection criteria, everything from the first set minus the values selected both the first and second time. Furthermore the values could be either numeric or text.

Sorry for any confusion.

Thanks

Karl