Drop Down Menu to Filter Data

[Chewyhairball]

Hi

Is there a way to use a data validation drop down list to filter results instead of adding a data filter.

The reason I ask is to simplify the filter process for not so computer literate people so they don't have to go through the process of unselecting all the selecting the required field.

I know the data filter is not complicated but a drop down menu would be easier for some folk.

cheers

Rory

 

[Chewyhairball]

What row does your data start in & what columns are used?

the data starts in row 7 ( title in 6) and goes to column AN. The test sheet that was working a minute ago is now not working.

 

[Chewyhairball]

the data starts in row 7 ( title in 6) and goes to column AN. The test sheet that was working a minute ago is now not working.

its like the change event is not working??

 

[Fluff]

In that case use

Range("A6:AN6").AutoFilter