Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I automatically hide or filter a row?
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically filter out blanks in multiple columns | Excel Worksheet Functions | |||
Help with a hide row macro (not using filter) | Excel Worksheet Functions | |||
How do I automatically hide columns in a worksheet based on a cell value? | Excel Worksheet Functions | |||
Filter Switches vs Macro? | Excel Discussion (Misc queries) | |||
How do I automatically hide rows | Excel Discussion (Misc queries) |