Lookup dropdown selection list without physically scrolling

[Brindle]

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.

[vcoolio]

Hello Brindle,

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

Please Login or Register  to view this content.

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.