| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hiding rows based value of cell within row
I have multiple worksheets, each with roughly 5 rows on them in the same
locations. What I want to do is, when a cell in column X among those 5 rows equals 0, hide that row. In other words, say rows 1 thru 5 have the following numbers in column X: 1, 4, 0, 4, 7. I'd like Excel to hide row 3. The thing is, the numbers change constantly because they are generated by a vlookup formula. So, row 3 may be hidden on one sheet, while row 5 is hidden on another. I know similar questions have been asked many times and the answer usually involves using a macro. The problem is, I have never worked with macros and would really appreciate a walk through. I am using Excel 2007. Please let me know if I need to clarify my question in any way. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hiding Specific Rows Based on Values in Other Rows | Excel Worksheet Functions | |||
| hiding rows based on cell contents | Excel Discussion (Misc queries) | |||
| Hiding rows based on a value | Excel Discussion (Misc queries) | |||
| Hiding Rows Based on Percentile | Excel Discussion (Misc queries) | |||
| Hiding rows based on date | Excel Worksheet Functions | |||
Hybrid Mode
