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 row, if that would work better). The worksheet would have,
say, 3 groups of 26 rows. I will be sharing the worksheet with others and I
want to make it as user-friendly as possible. 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. 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.