| 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 |
| 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 | |||
Threaded Mode
