| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hide Rows based on value
I would like to have a numeric value in cell D7 to indicate how many rows
beginning 12 - 71 are hidden from view automatically. Column B numbered 1 - 30 with additional row in-between for cosmetics which indicates number in row directly above. B12 = 1 B13 = 1 B14 = 2 B15 = 2 and so on so if D7 = 7, I would like for rows 26 through end of document to auto hide. Thanks for help |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return multiple rows of data based on criteria | Excel Worksheet Functions | |||
| resetting last cell | Excel Discussion (Misc queries) | |||
| How to hide and unhide Rows & Columns | Excel Worksheet Functions | |||
| Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
| Hiding rows based on choice in a listbox | Excel Discussion (Misc queries) | |||
Linear Mode
