Hiding Rows when referencing a worksheet

R

Ray

Hi, I am a new user and would appreciate some help with what is probably a
simple problem. Using the formula below I am copying data from one worksheet
to another based on if data exists in one of 3 cells. If there is no data in
either of these cells I would prefer to hide the row instead. How can I do
this?

=IF(JobList!$K2<>"",JobList!A2,IF(JobList!$L2<>"",JobList!A2,IF(JobList!$M2<>"",JobList!A2,"")))
 
P

Pete_UK

You could apply a filter to the column containing the formula,
selecting Non-blanks from the filter pull-down.

Hope this helps.

Pete
 
G

Gord Dibben

Using VBA.

Formulas cannot hide rows or columns.

They can only return results to the cell.


Gord Dibben MS Excel MVP
 
Top