Quote Originally Posted by teylyn View Post
Hi jaymanwani7,

you won't be able to do that with a data validation list. But if you use a listbox instead and a little VBA code that runs in the background, you can achieve autocomplete/autofilter functionality.

Have a look here: http://www.dailydoseofexcel.com/arch...mit-a-listbox/

....

Thank you for quick respone. Unfortunatley, I am good with excel but not good with VBA and I couldn't understand the VB code for boxes.

What do you reccommend? Can anyone upload a sample fil here. I know thats asking too much, but I really tried to understand what to do but couldn't.

I will highly appreciate if anyone can make sample excel file and I can use it as a tempelate.

Best,
Jay!