I am using Excel 2000. I would like to create a worksheet that would
automatically hide certain rows depending on a value in a cell in a different
row (or in the same row, if that would work better). I will be sharing
the worksheet with others and I want to make it as user-friendly as possible.

The worksheet would have, say, 3 groups of 26 rows. Some users may only use
6 or 7 rows in one group, and 10 rows in the second group, and perhaps no
rows in
the third group. Another user may use 10 rows in each of the three groups.
Each user will have a different need. I would like to be able to enter a
value into three cells and have the extra rows not appear in each group. I
do not want the user to have to go to the toolbar to hide or filter out rows
that are not used if that can be avoided. Is there any way to do this?

Thanks.