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 |
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 . |
All times are GMT +1. The time now is 02:50 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com