How to hide rows or cells based off another cells changing value (without VBA hopefully)

[1junktogold]

I have a workbook I am creating for coworkers to use. I am trying to eliminate a lot of rows to data to be scrutinized based off of a drop down cell on a different page. All rows will show if the value is one thing or only a few specific rows if the value is something else. I don't know how to do this without circular references. Pls help steer me in the right direction. Thanks in advance

 

[My Aswer Is This]

This would require Vba.
And we would need exact details on what sheet and in what cell is the drop down list.
What column will we look down for the value.

And we call things "Sheets" not "Pages"

 

[tonyyy]

A non-VBA approach might be to put your data into a PivotTable, create a Slicer for the data, then Cut/Paste the Slicer into the other page.

Oh, sorry, I meant Sheet, not page.

Cheers,

tonyyy