Hiding rows on condition
 

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!A11,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!!!

Hiding rows on condition
 

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


--
Don Guillett
SalesAid Software

"Catherine Bond" <Catherine wrote in message
...
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!A11,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!!!

Hiding rows on condition
 

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" wrote:


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


--
Don Guillett
SalesAid Software

"Catherine Bond" <Catherine wrote in message
...
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!A11,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!!!

Hiding rows on condition
 

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

--
Don Guillett
SalesAid Software

"Catherine Bond" wrote in message
...
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" wrote:


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


--
Don Guillett
SalesAid Software

"Catherine Bond" <Catherine wrote in
message
...
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!A11,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!!!