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
.