Auto Complete for Data Validation

[IJC]

Hi

How do I have the name appear in the cell C2 (sheet1) from the dropdown list : Example if I type the letters "am" in cell C2 (sheet1) then the name Armandip Sharda should appear and when I hit enter then the name is selected.When letters are typed in C2 (sheet1) then the most appropriate name appears

Thanks

IJC

[Admin]

Hi

There is no built-in way to accomplish this task for Data validation.

Use could try a ActiveX combo box.

May be this link will be useful. Auto Complete for Data Validation (http://www.ozgrid.com/Excel/autocomplete-validation.htm)