Hi

I have 2 columns list (on column A and B). The first Column (A) has 20
working teams (from an organization RBS), and the other columnn list (B) has
200 resources - about 10 resources for each team.

I want to have 2 data-validation lists. When the user select a certain team
from the drop down list at column C (of 20 teams in the list), he will only
get the relevant resources in column D (an automated filtered list that
matches the relevant resources to the certian team selected in column C).

Thanks in advance for any help on this matter.

Regards,
Shai