Filter a Drop List ?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top