Hiding rows on condition

[Guest]

Hi,

I am trying to set up a spreadsheet where you input master data on Sheet1,
then depending on what options are not checked off (with an 1), that row of
data will not appear on Sheet2.

I thought the easiest way would be to create an If statement, something like:
=IF(Sheet1!A1>1,Sheet1!A1,do not display this line at all)

Obviously, that doesn't work! Is there a function that will allow this to
happen?

Also, in the "VAlue_if_TRUE" spot, is it possible to tell it do display 2
cells of data?

Thanks!!!

 

[Don Guillett]

have you tried
=IF(Sheet1!A1>1,Sheet1!A1,"")

 

[Guest]

Thanks Don!

This has helped and I'm about halfway there now.
It is not showing any value when I don't want it to...
It there a way to then Hide the rows that have no value?

 

[Don Guillett]

A formula cannot hide a row. It may only return a value. To hide rows you
will need a macro.