hide rows if nil result of formula in specific column

J

Joy

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
 
G

Gord Dibben

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
 
E

Eddie O

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)
 

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

How to hide rows having a specific value in cell of column A ? 0
Formula result in multiple cells 1
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Formula Displays Instead of Result One Column Only 1
Drop down list control value in vba 2
need help in fine-tuning a formula that removes blank cells in a column range 3
Adding a big matrix in Word 2013 5
If value is true the check column for specific values 1

Top