Macro: Autopopulate Cells based on input in one cell

[decksie]

I need help with a macro. I've found lots of macros online that a described to do almost what I want but my VB grasp is never enough to modify it to my needs. I've bought a VBA book to teach mycself but I'm afraid I need this spreadsheet too soon to wait for me to upskill.

I'm creating a date entry spreadsheet that needs to accept data that I manually input from completed questionnaires. In short


In cell A2, I will enter a value 'Yes' or 'No'. I've made a drop down box through data validation.
If I enter 'No', I want to autopopulate cells A3:A9 and A12:A18 with "N/A"
If I enter 'Yes' I want those aforementioned cells to remain blank so that I can manually populate them.
I'd like this code to work equally for each column with the corresponding rows affected.

As a bit of bonus functionality, if it isn't difficult, If I accidentally enter 'No' in cell E2 and it autopopulates E3:E9 and E12:E18, if I change it back to 'Yes', can it cleat those N/As that shouldn't be there?

Thanks,
DD

 

[My Aswer Is This]

Glad I was able to help you.
Come back here to Mr. Excel next time you need additional assistance.

Thank you both

As 'My answer is this' says, the longer code is great for a learner like me who has a better chance of understanding the syntax and logic, making minor adjustments relatively easy if necessary. But of course, I hope to get to the level one day where one line of succinct code such as Rick proposed is all I need to solve these problems!

Cheers,
Dan