Dynamicly Hiding Rows or Columns

T

too much to view

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.
 
S

SunTzuComm

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.
 
E

Et3rnal

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