Hiding Rows when referencing a worksheet
 

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,"")))

Hiding Rows when referencing a worksheet
 

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

Hope this helps.

Pete

On May 15, 7:45*pm, Ray wrote:
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,"")))

Hiding Rows when referencing a worksheet
 

Using VBA.

Formulas cannot hide rows or columns.

They can only return results to the cell.


Gord Dibben MS Excel MVP

On Thu, 15 May 2008 11:45:05 -0700, Ray wrote:

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,"")))