Type Name to automatically appear from validation data list

[hafiff]

Hello Excel expert:

I would like to create several sheets and each will have a column for Client Name on it. To minimize the typing error, I have a sheet that contains only the client names as validation data list so I can just type the name on the new sheet as drop down list. I am able to set it this up; however, instead of drop down list, I would like a programming challenge where I just want to be able to do both:
1. Type a character "a" and it will show the list of just the names starting with a letter "A" and
2. Keep the drop down menu as usual.

Do I need to get dget function, etc. and I have not able to figure out the easiest way to accomplish this and your expertise are welcome to share please?

Thank you,
HA

 

[Akuini]

See if this helps:
Use a free add-in called "Search deList"

I created an Excel add-in called “Search deList”, to create searchable data validation

I created an add-in called “Search deList”, and I share it as a freeware. Its function is to speed up searching in data validation list. In any cell that has data validation (with List type) pressing ALT+RIGHT will open a Userform with a combobox. You can type multiple keywords (separated by a...

www.mrexcel.com