Auto-hide cells in one sheet based on the value in a cell in another sheet

Hi,

I have 2 sheets in my Excel Workbook, one called "Questions" and the other called "SOC".

I want to:

• If the value of cell B54 in "Questions" is "0", hide rows 68-120 in "SOC".
  If the value of cell B54 in "Questions" is "1", hide rows 81-120 in "SOC", and show rows 68-80 in "SOC".
  If the value of cell B54 in "Questions" is "2", show rows 68-120 in "SOC.

I've tried everything I can find online, and nothing results in any movement of the rows in "SOC" at all.

Would be grateful for some help!

I should add that I already have one VBA in the sheet I'm trying to do this in - does that affect how it works?