Trouble with data validation and filtering on a dropdown

[zura04]

Hi all,

I need help! I created a dropdown menu using Data Validation and a dynamic range, so that anything typed into the range automatically appears on the dropdown.

The formula I used for this was a Defined Name of:

=OFFSET('Priority List'!$C$6,1,0,COUNTA('Priority List'!$A:$A),1)

Where C6 is the header cell of the column and I want the range to go on to the end.

What I want to know is how I can filter that dropdown so that when I select "A" from the dropdown menu, all the rows that do not have "A" in the C-column are hidden (like what happens with Autofilter). Is there any way to do this?

I am pretty new to the tough aspects of Excel, so please try to keep it relatively simple.

Thanks!

[zura04]

....nobody?

[Carim]

Hi,

take a look at Debra's brilliant solution

http://www.contextures.com/xlDataVal08.html#Change

HTH
Carim