Hide rows based on muti cell drop down list

Hi guys, need help urgently on this.

Have Cell B39, which has Yes/No drop down option.
If no, then I want to hide rows 40-66.
If yes, then I want it to show row 40, hide rows 41-66.

Then, Cell B40 has Yes/No drop down option.
If no, then I want to hide rows 41-66.
If yes, then I want it to show row 41, hide rows 42-66.

Then, Cell B41 has 1,2,3,....,25 drop down options.
If 1, then I want it to show row 42, hide rows 43-66.
If 2, then I want it to show row 42 and 43, hide rows 44-66.
If 3, then I want it to show row 42,43, and 44, hide rows 45-66.
and so forth..

Can someone please help me? I don't have experience with Macros/VBA.

Try this (insert code in relevant Worksheet Module)

Please Login or Register  to view this content.

Ok hopefully the attachment has come up..

@mgs73, that didn't work.

Hi, sorry because I don't know what codes to add, I do not have any experience with VBA etc. The code posted above didn't work too.

Sorry as I mentioned in my initial post, what I am trying to achieve is:

Have Cell B39, which has Yes/No drop down option.
If no, then I want to hide rows 40-66.
If yes, then I want it to show row 40, hide rows 41-66.

Then, Cell B40 has Yes/No drop down option.
If no, then I want to hide rows 41-66.
If yes, then I want it to show row 41, hide rows 42-66.

Then, Cell B41 has 1,2,3,....,25 drop down options.
If 1, then I want it to show row 42, hide rows 43-66.
If 2, then I want it to show row 42 and 43, hide rows 44-66.
If 3, then I want it to show row 42,43, and 44, hide rows 45-66.
and so forth..

@mgs73, just tried again and it worked! thank you soo much.