Hello,

I wonder if anyone can help me please ?

Firstly, apologies if what I am asking for is not possible, or if it
has been asked before, but I've had a look, and can't seem to find it.

I have a spreadsheet which I distribute weekly to certain people.
It is basically a top level view of incidents, which shows the
following.

Sheet Number 1 is :
Person - Count
Joe Bloggs - 42
Fred Bloggs - 12

And so on.

This shows me a summary of how many incidents per person have been
logged.

Sheet Number 2 is the actual raw data for that count, so it shows every
line.
So in the above example, there would be 42 lines for Joe and 12 for
Fred.

What I'd like is to put a hyperlink on sheet 1, whereby if you click
onto Fred's name, it will take you to sheet 2 and autofilter to only
show Fred's records (i.e 12 of them)

Firstly is this possible ?
Secondly can anyone point me in the right direction of where to start ?

Thanks in advance.

J.