Validation that allows a prompt when i type say a letter "A" it drops down all list with "A"

[odartey]

Dear All,
I am creating a list using a data validation. so far it suffices what i am doing.
I now want to step it up such that i need not drop down the list, but when say the letter "A" is typed it will drop down all list that start with "A" or type "AD" and it also populates the list with just "AD" and i am told a VBA code can help achieve that.
I will be grateful if members can help me achieve this.

Thanks in anticipation for response.

 

[Sathish KV]

Hi,

Check out the below link

http://forum.chandoo.org/threads/dropdown-based-on-search-string.15410/#post-96096