Raw Data Filter

[RPM1980]

Please could someone offer some advice or tell me if its even possible.
I have a spreadsheet with 2 tabs. The first tab has raw data. Row 1 is the column titles and the raw data goes from A2: CJ5000.
The second tab is a results sheet that has formulas to average and count if certain criteria is met. I have used countifs & averageifs to pull the results from the raw data.
What I would like to do if its possible, is to click on a value in the results tab and it take me to the raw data that creates that result.

I can find the raw data manually by applying filters to the raw data sheet but it would be much easier to click the result and then excel apply the filters to show me the raw data.

 

[RobP]

Hi

in case you are able to use Macros in your workbook, this is a solution I have used in the past in order to switch between one sheet and another with a unique value identifier..

You need to change the Sheet names according to what yours are ("RAW Data Sheet", and "Results Sheet") in my code.
Also, the code assumes that your unique reference number is residing in column (1) on each sheet. You can adjust that to col 2 or whatever in both locations of the code on the "Set Found = " row.

Then you save the workbook as a macro enabled book, and assign a Key to the macro in order you can invoke it with Key strokes. Personally I assigned Alt+S, meaning when I hit S while holding down Alt with my left hand, it switched sheet to the correct line that you have currently highlighted your cell from.

Hit it again and you'll switch back.

Hope it helps

Cheers
Rob

Sub f_val()

Dim ws As Worksheet, Found As Range
Set ws = IIf(ActiveSheet.Name = "RAW Data Sheet", Sheets("Results Sheet"), Sheets("RAW Data Sheet"))
Set Found = ws.Columns(1).Find(what:=Cells(ActiveCell.Row, 1).Value, LookIn:=xlValues, lookat:=xlWhole)
If Not Found Is Nothing Then
    Application.Goto Found
End If
End Sub