Dynamicly Hiding Rows or Columns

Does anyone know how to hide a row or column based on
what its content is?

E.G. If I have a sheet with multiple client's
information on it; how do I hide the rows that do not
deal with the client I'm interested in at the moment. I
need to have them all in the single sheet. This is a lot
of information, so the brute force method is undesirable.

If you have some sort of client identifier in (a name or number) in each row,
you can use AutoFilter. That will hide only rows, however.

This may be the long way to solve this, but if your clients stay in this
file, then the work could be worth it. Set up individual macros to
hide both selected rows and colums you chose. Assign this macro to a
button. You can do a seperate one for each client.


---
Message posted from http://www.ExcelForum.com/