Need similar functions in different cells in one worksheet needed.

I have a worksheet where I'm hiding and unhiding data based on the response to drop down list question of <blank>, yes, or no. I have the function worked out for one question, but how do I do this for multiple questions?

i.e. - Z20 contains the response of <blank>, yes or no. If yes, unhide rows 21:22. If no, hide rows 21:22.
Z132 contains response of <blank>, yes or no. If yes, unhide rows 133:153. If no, hide rows 133:153.

This will repeat in this worksheet many times. I need to know how to start this, finish this and add to it as needed without completely destroying it.

I'm completely new at this and have no idea what I'm doing. Your help is appreciated.

I think this may do the trick for you. You'll need to paste this code into the worksheet module (see attached picture)

Please Login or Register  to view this content.

Thanks so much! Worked perfectly.