Hi J

You must use a macro
Try this example with the names in Sheet2 in column A

Select a cell with a name in Sheet1 before you run it

Sub Filter_with_Autofilter()
Dim FilterValue As String
FilterValue = ActiveCell.Value

With Sheets("Sheet2")
.Range("A1:A100").AutoFilter Field:=1, Criteria1:=FilterValue
.Select
End With
End Sub



--
Regards Ron de Bruin
http://www.rondebruin.nl


wrote in message ups.com...
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.