extract name from inputting partial text

[jlutz]

Hi Everyone,
I've searched this forum as well as Excel is fun and haven't been able to locate what I'm looking for.

I have a column which is currently in data validation to bring up all of the names on a different worksheet. It works fine but all of the names appear in the drop-down box.

I'm trying to make things more efficient by inputting a letter (a) in a cell and having all the names (first last) appear to be selected. So by inputting "A", any name beginning with "A" would appear, i.e. Aaron Smith, Andrew Jones, etc. Obviously, this would work with all letters.

I trust that makes sense.

Thanks for the help in advance.

 

[VoG]

Which version of Excel are you using? If Excel 2007 or later you need to add an ActiveX combobox (from the lower group of controls when you click Insert on the Developer tab).