Data Validation list search

A

Aligahk06

Dear All,

In data validation we have more than 5000 lists and their corresponding
records.

Looking an item in the list manually is quite trouble and scrolling upto
5000 lists is tedious.
Can i have a technique that we can find our list either by serching or
finding techniques once a
particular item list is looked.

Please assist ?

Rgds,

Alighak06
 
L

L. Howard Kittle

If you decide to stay with the Data Valaditation drop down, try this:

Sort your validation list and at the beginning of the A's enter a single A,
do the same for the beginning of the B's and all the way through to the Z's.

Click in the cell that has the drop down validation and type in the letter
of the list you desire... say you type in an O. DO NOT hit enter... leave
the cell in the edit mode (still selected) and now hit your down arrow.

Should take you to the O which is the top of the O list of selections.

HTH
Regards,
Howard

You might like to think about using a combo box, as this has auto-
complete. Debra Dalgleish takes you through it here:

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

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top