Conditionally Hide Rows

[Crownman]

I have a spreadsheet where I would like to be able to hide selected
rows if a specific cell within that row meets a specific condition.
The conditional cell is a cell reference to another sheet within the
workbook.

Does anyone know if this can be done and if so how?

Thanks in advance for your advice.

Crownman

 

[Dave Peterson]

Maybe you can select the column and apply Data|filter|autofilter to hide/show
the rows you want.

Debra Dalgleish has some notes here:
http://www.contextures.com/xlautofilter01.html