I looked at your Excel file.
I don't understand how exactly to configure the 2 drop-down Data Validation,
especially the second one that shows only the values of the range
corresponding with the type of animal?

Thanks for advance for any help on this matter.

Regards,
Shai


"Ed Ferrero" wrote:

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