Hi all,

i have a situation where i need to create a hyperlink and write a macro for a auto filter in sheet1 cell B$2 for a table in sheet2 and return the count of the fields retrieved to be displayed in cell B$2 of sheet1.

The code i used below created a hyperlink which when clicked moves to sheet2 and displays the filtered data as per the condition given but i need the count of the filtered cells to be displayed in the hyperlink cell B$2 of sheet1.

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
If Target.Range.Address = "$B$2" Then
With Sheets("Sheet2")
.Range("A2").AutoFilter Field:=4, Criteria1:="Resolved/Fixed"
End With

Can anyone help me with this??!!