Hiding Rows when referencing a worksheet

  • Thread starter Thread starter Ray
  • Start date Start date
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,"")))
 
You could apply a filter to the column containing the formula,
selecting Non-blanks from the filter pull-down.

Hope this helps.

Pete
 
Using VBA.

Formulas cannot hide rows or columns.

They can only return results to the cell.


Gord Dibben MS Excel MVP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sumifs problem 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Populate row with work days 1
Changing relative cell reference 2
Delete Rows based on condition 2
auto hide blank rows 1
Referencing a cell's data & format in Excel 2004 for Mac 1
hide, unhide column or row after protect worksheet 4

Back
Top