Hide rows based on prior setup sheet

[edjohn20]

I know there is VBA code to do this. I don't know VBA well enough to write it. However I know exactly what I want to do.

I have a worksheet 1 titled "Setup" and worksheet 2 titled "MMS PaaS Pricing 2024"

I have configurable in Setup B4 to B11. This field will be either YES or NO (chosen from drop down)

core
IF b4=NO the Hide "MMS PaaS Pricing 2024" rows 9-15
cm
IF b5=NO the Hide "MMS PaaS Pricing 2024" rows 16-21
sc
IF b6=NO the Hide "MMS PaaS Pricing 2024" rows 22-30
acm
IF b7=NO the Hide "MMS PaaS Pricing 2024" rows 31-38
ssm
IF b8=NO the Hide "MMS PaaS Pricing 2024" rows 39-46
lca
IF b9=NO the Hide "MMS PaaS Pricing 2024" rows 47-55
web
IF b10=NO the Hide "MMS PaaS Pricing 2024" rows 56-63
movr
IF b11=NO the Hide "MMS PaaS Pricing 2024" rows 64-69

There are also formulas and values within the cells to be hidden that need to be suppressed as well. Meaning if SC section is NO then the fees and values do not get included.

 

[edjohn20]

Got it, thank you. It works like a charm