Filtering Question

  • Thread starter Thread starter Brent
  • Start date Start date
B

Brent

I have a list of 20 Names to filter in a list.

If I select one of the names, I would like the name to appear in a cell at
the top of the page.

Also, If I choose more than one name or all of the names, then I would like
to it equal the words "Master List"

Any ideas on how to do this. (Excel 2007)

Thanks,!
 
The first part can be achieved by Data>Filter>Autofilter.

Select a name from the list and the rest will be hidden.

The second part does not make sense to me.

What is the "it" that should equal "Master List"?

Please re-post.


Gord Dibben MS Excel MVP
 
Back
Top