sq30
asked on
Autofilter criteria from cell and refresh at cell change
Hello,
I'd like the code below to be able to pick up the autofilter criteria from cell A1 and re run this code everytime the value in cell A1 changes.
Thanks in advance
I'd like the code below to be able to pick up the autofilter criteria from cell A1 and re run this code everytime the value in cell A1 changes.
Thanks in advance
Private Sub filter()
Sheets("filter").Select
With ActiveSheet
.AutoFilterMode = False
.Range("A17:J42").AutoFilter Field:=6, Criteria1:="A1"
End With
End Sub
test-filter.xlsm
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Glad to help, thanks for the grade.
Thomas
Thomas
ASKER