Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation List
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation List
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). Brooke wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a blank in Data Validation List? | Excel Discussion (Misc queries) | |||
Choices from Data Validation List | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions |