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?