Looking for help please... if a value changes in one worksheet, I want the filter (in another worksheet) to update automatically, but I keep getting ""Compile Error: Invalid or Unqualified Reference". My code is attached below.
Can anyone please help.. what am I doing wrong?
Peter
------------------------
Private Sub Worksheet_Change(ByVal Target As Range)
'Look for any changes to worksheet "Sizing Tool", specifically cell I60
If Target.Address = "I60" Then
'If there are any changes, apply these to worksheet "PV"
Worksheets("PV").Range("$A$16:$BO$100").AutoFilter Field:=6, Criteria1:=Worksheets("Sizing Tool").Range("I60").Value
.AutoFilter.ApplyFilter
End If
End Sub
------------------------
Can anyone please help.. what am I doing wrong?
Peter
------------------------
Private Sub Worksheet_Change(ByVal Target As Range)
'Look for any changes to worksheet "Sizing Tool", specifically cell I60
If Target.Address = "I60" Then
'If there are any changes, apply these to worksheet "PV"
Worksheets("PV").Range("$A$16:$BO$100").AutoFilter Field:=6, Criteria1:=Worksheets("Sizing Tool").Range("I60").Value
.AutoFilter.ApplyFilter
End If
End Sub
------------------------