Data validation doesn't support autocomplete. If you can use
programming, there are instructions here for adding a combobox from
which you can select one of the values from the data validation list. In
the combobox, you can enable autocomplete:

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


FeFi wrote:
I have set up a data validation list which contains a large number of
entries. At present, if an entry requiring validation is not exact it
triggers the error message requiring me to scroll through the list to find
the correct data. I would like to enter a partial value in the cell which
would scroll the list to the general area in which to find the information
needed? Is this possible and if so, how?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html