One way is to enter the last name to find in A1 and execute the marco below;
'It will select the cell, in Col A, containing the same last name as in A1
Sub FindSelect()
Dim c As Range, s As Long
Range("A2:A65000").Select
Set c = Selection.Find(Range("A1").Value)
If Not (c Is Nothing) Then
c.Select
Else
Range("A1").Select
MsgBox "Last Name: " & Range("A1").Value & " not found!"
End If
End Sub

"doss04" wrote:

I have a list of names on a worksheet. I would like to have a search box at
the top of the page. That when i type in the last name it will go to it. is
that possible?