Automatically re-filter when I change a value in a cell

[Porcupine_]

Hello,

I have a column starting from cell D22, which is set on a filter to eliminate the value "N" and keep the value "Y". The value ("Y" or "N") is generated by a formula that looks at whether the corresponding value in column A matches a value selected from a dropdown list in cell A6.

The problem is, whenever I change the value in cell A6, the column D does not re-filter to show only "Y" values, and is left with "N" values.

I am looking for a way to re-apply filters on the sheet whenever I change a value in Cell A6.

I have tried using this VBA:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
ActiveSheet.AutoFilter.ApplyFilter
End Sub

But it isn't working for me - it doesn't come up with an error, but it just doesn't re-filter.

Is anybody able to help with this?

Thank you,

Vicky

 

[Porcupine_]

Re: Automaticlaly re-filter when I change a value in a cell

Yes I have closed and re-opened the file a few times - still not working
It is data validation, yes - and I have tried making the source data (the possible list items) come from a list defined in some other cells, or written manually into that 'source' box in the data validation section

 

[Fluff]

Re: Automaticlaly re-filter when I change a value in a cell

Check your trust center settings (in options) and make sure that macros are enabled.

 

[Porcupine_]

Re: Automaticlaly re-filter when I change a value in a cell

Yes it's worked! Thank you!

 

[Fluff]

Re: Automaticlaly re-filter when I change a value in a cell

Glad to help & thanks for the feedback