Hello, I would really need a helping hand with a VBA code intended to autofilte a target column in a sheet (Sheet2) when the user clicks on different hyperlinked cells, stored in a column on another sheet (Sheet1). I found the VBA below, it activates the hyperlink, but it works only for the first row in the target table. So, no matter what row I click in the column where I have the hyperlinks stored, the filter works only once, for a single value. The values source column may change constantly, so I think the Criteria1 part should require attention here…
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
.AutoFilter Field:=1, Criteria1:=ActiveCell.Value
Thank you very much.