hide rows if nil result of formula in specific column
 

Hi,

I need to pull information from one multiple spreadsheets to another purely
by formulas and have rows with a nil value result in a specific column hide
themselves automatically in my destination spreadsheet.

Thanks

Joy

hide rows if nil result of formula in specific column
 

Rows cannot be hidden by using a formula.

You can make a cell look blank by using a formula.

=IF(Sheet1!A1="","",Sheet1!A1) entered in A1 of Sheet2

You can hide rows by filtering out blank cells in a column.

You can use VBA to hide rows based upon blanks in a column.


Gord Dibben MS Excel MVP

On Sun, 28 Feb 2010 17:14:01 -0800, Joy
wrote:

Hi,

I need to pull information from one multiple spreadsheets to another purely
by formulas and have rows with a nil value result in a specific column hide
themselves automatically in my destination spreadsheet.

Thanks

Joy

hide rows if nil result of formula in specific column
 

One of these may work for you. Where "Sheet1" is the sheet you're pulling in
data from:
=if(isblank(Sheet1!A1),"",Sheet1!A1)
=if(Sheet1!A1=0,"",Sheet1!A1)


"Joy" wrote:

Hi,

I need to pull information from one multiple spreadsheets to another purely
by formulas and have rows with a nil value result in a specific column hide
themselves automatically in my destination spreadsheet.

Thanks

Joy