Hyperlink to another sheet & show filtered data

[LookingToLearn]

Hi All,

Hoping someone can help.

In my workbook i have two sheets ("SR Data" and "Summary"). "SR Data" is where i drop all my raw data and "Summary" is where i use different formulas (Countifs mainly as most of the formulas have 5/6 criteria) to make my data useable.

I want to be able to click on a formulae result in the "Summary" sheet and it take me to the "SR Data" sheet with the corresponding criterias filtered.

For example;
on the "Summary" sheet i have this formula in cell C1 =IFERROR(COUNTIFS('SR DATA'!$G:$G,$A6,'SR DATA'!$B:$B,"Retail",'SR DATA'!$K:$K,"Used",'SR DATA(HELPER)'!$W:$W,">="&$C$2,'SR DATA(HELPER)'!$W:$W,"<="&$E$2),0) and it returns the value 6. I want to be able to click on the number 6 in C1 and it take me to the "SR Data" sheet and for those 6 data lines to be shown.

There's hundreds of lines of data so this will help save time from filtering every time i need to information.

I'm pretty sure it can be done (Vba / hyperlink) not bothered how just as long as it works

Thanks in advance people.

 

[LookingToLearn]

Ive seen this code on here maybe something along these lines?

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Target.Column <> 2 Then Exit Sub
Dim last As Long
last = Sheet2.Cells(Rows.Count, "A").End(xlUp).Row
Sheet2.Range("A1:L" & last).AutoFilter
Sheet2.Range("A1:L" & last).AutoFilter Field:=12, Criteria1:=Target.Value
Cancel = True
Application.Goto Sheet2.Range("A1")
End Sub