Hello
We have an excel template that has multi sections. We would like to create a macro that would hide rows based on what is in column P.
So as an example first section is lines 14 - 28 , if P14 = 0 then would want to hide the row. What the user would like is to leave one
blank row visible after the last used row. So , as an example, if rows 14 - 18 contain a 1 in P, then they would want row 19 to remain visible and hide rows
20 - 28.

Thank you!