Hello everyone,

I am trying to build an automatic reporting tool
I have a data validation list in the report which drives some formulas.
I would like to also link the selection of the data validation to an autofilter on the raw data (graph of teh raw data would then also be driven by the data validation selection)

I have been using this following code (embedded in "RAW" data sheet) and a random cell (B1) to the data validation selection.
My problem is that it doesn't automatically update, I have to select the sheet for it to work

Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Range
If Target.Address = "$B$1" Then
 Set r = Me.AutoFilter.Range
 r.AutoFilter Field:=13, Criteria1:=Range("B1").Value
End If
End Sub
is there any way to link it directly to the data validation list so that the autofilter updates everytime the data validation selection is changed (in cell C3)


Thanks