Need Help altering my VBA code.

Hi,

Please can someone help me to put a couple of issues right?

At the moment when an operator selects Azera, L, M,and N from the drop down menu in cell E it puts a "YES" in cell L, but if the operator was to select say L by mistake and then selected K, the "YES" still stays in cell L.

I would like when I change the letter in cell E drop down menu cell L also changes to suit.

Azera, L, M, and N = YES all the others to say N/A.

Also i'd like it if you could help me so when I deleted whatever is in cell E, its also deleted whats in cell L.

Any help on this would be appreciated.

Kind Regards
Dan