I
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
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