software

I have been able to use the method at this web address to hide used
validation list items of a single list, www.contextures.com/xlDataVal03.html.

Dropdown List Example:
SI-01
SI-02
Si-03
etc.

When SI-01 is selected from the dropdown (DD) list, it is no longer
available in the DD list and, thusly cannot be selected again by mistake.
Perfect.

I want to have multiple lists such as:
SI-01 PR-01 CCD-01
SI-02 PR-02 CCD-02
SI-03 PR-03 CCD-03
etc. etc. etc.

and when I input quot;PRquot; into a cell, only the quot;PR..quot; list is available in the
next cell DD list. I can do that too by using the method found at
www.contextures.com/xlDataVal02.html.

The problem is, when I use the quot;DataVal02quot; method, it does not eliminate the
quot;PR-01quot; (when previously selected) from the DD list the way the quot;DataVal03quot;
method does. I need the hide feature of quot;DataVal03quot; in the multi list feature
of quot;DataVal02quot;. Can anyone help?