Hiding Rows on a Second Sheet, based on the cell value on a First Sheet

[mikeb7500]

I thought I already posted this, but it said I was logged off, so I apologize if this question appears twice.

On sheet named "Proposal", if N7=0, I need sheet named "Closing Statement" Rows 6-24 to auto-hide.

If "Proposal" N7>0, I need the "Closing Statement" Rows 6-24 to un-hide.

Currently the cell N7 contains "=SUM(H7,L7,M7)" which determines the value as 0, or more than 0.

Really need some help on this one folks...Thanks in advance!

 

[InOverMyH3ad]

Hi Logit,
I actually posted a similar question but I can't seem to get this code to work for my application. Any pointers? Any help would be greatly appreciated!


https://www.mrexcel.com/forum/excel-questions/1071014-another-automatically-hide-rows-question.html