Lookup dropdown selection list without physically scrolling

We have 120 or so employees, but only 15 work each time period. I have an Excel sheet with all their names. I want be be able to go to a cell, type the first letter of their last name and go to the portion of the alphabetized list with their name. I know this can be done in a drop down list, but that involves physically scrolling down the list after the first group of names and this is tedious. Is there some way I can use a first initial letter selection and automatically be taken down the list to the name that starts with that initial? Then I will select that person (or scroll down the list for other nearby names) and enter his or her name and hours in another sheet.

Hello Brindle,

Following is a code I did for another Poster elsewhere quite some time ago:-

Private Sub Worksheet_Change(ByVal Target As Range)

If Intersect(Target, Range("L1")) Is Nothing Then Exit Sub
If Target.Count > 1 Then Exit Sub
If Target.Value = vbNullString Then Exit Sub

For Each cell In ActiveSheet.Range("A2:A10")
    If UCase(cell.Value) Like UCase("*" & Target & "*") Then
    cell.EntireRow.Select
    End If
Next

End Sub

It is a Worksheet_Change event and needs to be placed in the worksheet module of your main sheet. Obviously you would have to change the range to suit yourself.

I've attached the sample work book I did for the Poster back then, but I feel that you may need an add-in to act more like a Google search box so have a look at the following link:-

https://www.excelcampus.com/vba/sear...op-down-lists/

It may be just what you need and I believe that it is free!

Cheerio,
vcoolio.