M
Mike Hogan
Is it possible to hide a row only if a certain cell in the
row contains a reference to another cell that has a specific
value?
Here's the scenario:
Column A of a Summary sheet contains a list of 20
categories. Each category row contains references to
data on another worksheet. Often, there is no data for
a specific category, so the Summary sheet displays the
category with zeroes or various errors depending on the
formulas referencing the data.
I would like to hide the entire row if the referenced data
cell contains a certain value, for instance "0". Can it be
done? Thanks for any help.
Mike Hogan
row contains a reference to another cell that has a specific
value?
Here's the scenario:
Column A of a Summary sheet contains a list of 20
categories. Each category row contains references to
data on another worksheet. Often, there is no data for
a specific category, so the Summary sheet displays the
category with zeroes or various errors depending on the
formulas referencing the data.
I would like to hide the entire row if the referenced data
cell contains a certain value, for instance "0". Can it be
done? Thanks for any help.
Mike Hogan