Filter a Drop List ?

[Isis]

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

 

[Gary''s Student]

See:

http://www.contextures.com/xlDataVal02.html