I need to have several drop down lists that depend on the choice of any of
the other drop down lists. All the drop downs will have the same list or
source but when I select an option for one of the lists then the other lists
need to have that option removed as a choice. For example, if I have lists
that show 1,2,3,4,5 and I select 2 for one of the lists then the other drop
down lists need to have 2 removed as an option and now display 1,3,4,5. And
so on, so that the choices are continually removed as selected.

See Debra Dalglesih's site for hiding previously used items.

http://www.contextures.on.ca/xlDataVal03.html


Gord Dibben MS Excel MVP

On Wed, 12 Aug 2009 12:15:01 -0700, Texas10
wrote:

I need to have several drop down lists that depend on the choice of any of
the other drop down lists. All the drop downs will have the same list or
source but when I select an option for one of the lists then the other lists
need to have that option removed as a choice. For example, if I have lists
that show 1,2,3,4,5 and I select 2 for one of the lists then the other drop
down lists need to have 2 removed as an option and now display 1,3,4,5. And
so on, so that the choices are continually removed as selected.