Great thank you! I just have two more questions, sorry this model is getting to be more complext than imagined.

I am trying to copy and paste that code and change it to do the same thing for line C2 and further down however it is not working. Do you know what I have to change to allow the code to do more than just outputs from C1, "Yes" or "No"?

And my last question is, how can I put it in there that if "Yes" then make cell G1=1, H1=1, I1=500, J1=200, K1=400 and do that for drop box in C2.. C3 etc.