Type first Letter to Populate Data Validation

[kumara_faith]

Hi,

I have a long list of data validation. I was wondering if there is a way when I clik on the drop down menu and type the first letter, automatically Excel shows all list with that letter.

Right now, I have to click on the drop down menu and scroll manually until I reach that desired list.

Thanks.

 

[Andrew Poulsom]

This may help you:

http://www.contextures.com/xlDataVal11.html

 

[wilnexpc]

This works like a charm.

This may help you:

http://www.contextures.com/xlDataVal11.html