Auto Hide Rows based on contents of cell

[mykeee]

I was just wondering if there was some way to set up a spreadsheet so that certain rows would be hidden or visible depending on the contents of a particular cell. What I am trying to create is a checklist to create a product. There is a list of tasks (one task per row) and depending on what product you select from a list in a particular cell, the spreadsheet would hide the tasks (rows) that are not applicable and show the ones that are needed.

Any ideas?

 

[texasalynn]

take a look at this similiar post