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

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

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