Hey there, I'm looking for some help. I'm not familiar with VBA and I'm not entirely sure of the best way to do the following.

I have drop down list with 2 options, (Yes or No for example, but will change) and would like to:
- Make it so any associated cells/formulas essentially "ignore" certain cells, based on the drop down value.
- Yes(C16): will make it so the worksheet will act as though C18 & C19 don't exist (or are blank?)
- No(C16): so the worksheet will act as though C17 doesn't exist (or is blank?)

As well as hide(or show if other option is chosen) the rows/cells in which the "ignored" cells are located.
- Yes(C16): will hide rows 18 & 19 (but show 17)
- No(C16): will hide row 17 (but show 18 & 19)


Also, is there a way to add a row below another while continuing the formating of the above row, with a button perhaps? Also another button or symbol on that row to delete it?

So, If anyone could help me out it would be appreciated.
Thanks!