Help with Data Validation Lists

Hi

I want to data validate two lists where the value choices are the same. Each list takes its data validation choices from a defined range. However, when a user selects a value from the first list, the corresponding value on the 2nd list will not have the value the user just selected.

Thus, when user selects A on List A, the dropdown box for List should only contain the choices which he did not select.

List A List B
-----------
A B
B C
C D
D

Can anyone help? Thanks

See this:

http://contextures.com/xlDataVal03.html

Biff

"KellTainer" <KellTainer.2cz3f8_1156302910.588@excelforum-nospam.com> wrote
in message news:KellTainer.2cz3f8_1156302910.588@excelforum-nospam.com...
>
> Hi
>
> I want to data validate two lists where the value choices are the same.
> Each list takes its data validation choices from a defined range.
> However, when a user selects a value from the first list, the
> corresponding value on the 2nd list will not have the value the user
> just selected.
>
> Thus, when user selects A on List A, the dropdown box for List should
> only contain the choices which he did not select.
>
> List A List B
> -----------
> A B
> B C
> C D
> D
>
> Can anyone help? Thanks
>
>
> --
> KellTainer
> ------------------------------------------------------------------------
> KellTainer's Profile:
> http://www.excelforum.com/member.php...o&userid=34322
> View this thread: http://www.excelforum.com/showthread...hreadid=574458
>