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