| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Box that sorts
How can I make a drop-down box that will take a column of data and allow a
user to view only selected data. Example: There are 6 Andys and 4 Bettys and 5 Tonys and 10 Gingers. I want all of their names to appear but I want the option to just view the selected names - as chosen from the drop down field like a sort. I've tried Data Validation but I am missing something Thanks in Advance -- Very Thankful |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down Box that sorts
Data Filter AutoFilter........then select the name you wish to view in
the dropdown arrow at the top of that column........Data Filter AutoFilter again to return all to normal...... Vaya con Dios, Chuck, CABGx3 "Joey041" wrote in message ... How can I make a drop-down box that will take a column of data and allow a user to view only selected data. Example: There are 6 Andys and 4 Bettys and 5 Tonys and 10 Gingers. I want all of their names to appear but I want the option to just view the selected names - as chosen from the drop down field like a sort. I've tried Data Validation but I am missing something Thanks in Advance -- Very Thankful |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limit drop down list and linking to other info | Excel Worksheet Functions | |||
| drop down box leading to another drop down box | Excel Discussion (Misc queries) | |||
| multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
| advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Linear Mode
