Data Validation List

[Guest]

I've created a data validation list with over 100 combinations. I was
wondering if there were "Hotkeys" that I could set-up that if someone choose
the list box and wanted everything that had a 4 it would list it first.

For example in the list I would have the following container inventory -
2 FL
2 FY
XF2
YF2
3 FL
3 FY
4 FL
4 FY
YF4
XF4

If the sales rep picked 4 yd as there container I would like it to list
those containers containing 4 first. What would be my best way of doing
this??

Thanks
Brooke

 

[Dave Peterson]

Not using a single data|validation cell.

But there are alternatives. You could give the user a dropdown where they can
tell what they want to start with. Then after they chose that, a second
dropdown would only display the entries associated with that first choice.

Debra Dalgleish shows how to do this:
http://contextures.com/xlDataVal02.html

=====
Another alternative, would be to sort your list and use a combobox from the
control toolbox toolbar. You can set that up so that it tries to complete the
entry based on what you typed (it'll jump down to the T's when you type that
first T).