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
.