Choices from Data Validation List

[Guest]

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?

 

[damorrison]

Hi,
Check out

http://contextures.com/xlDataVal02.html

there are many examples and will be easier to explain, there may be
something in there that will help you,
if data validation doesn't work you may have to go VBA, such as active
X or a UserForm, or a worksheet selectionchange event, But check out
the examples at contextures first

 

[Debra Dalgleish]

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