This strikes me as a fairly basic problem, and there are many threads that tackle similar issues, but my confidence in excel programming is such that I could use some very specific help.

On my first sheet entitled "Questions" I have a number of fields with Y/N drop down options. On my second sheet entitled "Trader Calc" I have about a hundred rows of complex calculations. What I'm looking to do is hide rows on this "Trader Calc" sheet based on the answers to the drop-down questions. For example, choosing "N" for G10 will hide rows 45 to 50.

Thank you in advance for your help!