ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Hide Rows based on value (https://www.excelbanter.com/excel-discussion-misc-queries/96409-hide-rows-based-value.html)

SteveT

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


All times are GMT +1. The time now is 08:43 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com