Hi Shai,

There is a sample of how to do this here -
http://www.edferrero.com/CascadingCellValidation.xls

Ed Ferrero (who will one day update his website)

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