Take a look at Auto Filter.
Click a cell in your database and go Data/Filter/Auto Filter
Rgds,
ScottO

"RJQMAN" wrote in message
...
| 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.
|