Hiding Rows Conditionally
 

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

Have you checked out AutoFilters? See:

http://www.contextures.com/xlautofilter01.html

HTH
Jason
Atlanta, GA

-----Original Message-----
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
.

Thanks much for the help. I had to do a little re-organizing of the
sheet to comply with the filtering format, but it's working. I never
played with filters before, just hid the rows manually. Now that I see
how they work, I'll plan ahead when laying out sheets. Thanks again.

Mike
Benton, TN (not too far from you)

Jason Morin wrote:
Have you checked out AutoFilters? See:

http://www.contextures.com/xlautofilter01.html

HTH
Jason
Atlanta, GA


-----Original Message-----
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
.