Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter a Drop List ?
I have Range of cells that all have drop downs with a list of names in
them - these come from a named range n another sheet. Is there a way to filter this list so that I can have the name appear in the drop down based on a criteria. The list is a staff list - I want to maintain the source of the drop down with all names, but limit choice to those available now - these can be marked with a 1 or something in the cell next to them, something like that. So the Drop Down contains a subset of a Range called StaffList Hope that is clear Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filter a Drop List ?
See:
http://www.contextures.com/xlDataVal02.html -- Gary''s Student - gsnu201001 "Isis" wrote: I have Range of cells that all have drop downs with a list of names in them - these come from a named range n another sheet. Is there a way to filter this list so that I can have the name appear in the drop down based on a criteria. The list is a staff list - I want to maintain the source of the drop down with all names, but limit choice to those available now - these can be marked with a 1 or something in the cell next to them, something like that. So the Drop Down contains a subset of a Range called StaffList Hope that is clear Thanks . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i filter dependents already selected in drop down list | Excel Discussion (Misc queries) | |||
Filter Data using a drop-down list | Excel Worksheet Functions | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Excel - how do I use drop down list to filter data | Excel Worksheet Functions | |||
re-ordering the list on a filter drop down | Excel Discussion (Misc queries) |