software

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?
Hi,
Check out

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 firstData 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:

www.contextures.com/xlDataVal11.htmlFeFi wrote:
gt; I have set up a data validation list which contains a large number of
gt; entries. At present, if an entry requiring validation is not exact it
gt; triggers the error message requiring me to scroll through the list to find
gt; the correct data. I would like to enter a partial value in the cell which
gt; would scroll the list to the general area in which to find the information
gt; needed? Is this possible and if so, how?
gt;
gt;--
Debra Dalgleish
Excel FAQ, Tips amp; Book List
www.contextures.com/tiptech.html