Hey People I'm drowing here.

Im looking for code that will allow me to enter a number (1,2,3 or 4) into any "A" cell and then cell C,D,E,G in that same row will have YES,NO,YES,YES.

E.g. I enter 1 in any "A" cell and that then adds Yes into Cell "C" - No into Cell "D" Needs to be on the same row as the 1 entered in Cell "A" - (and so on).

Then later I could have if you enter 2 in cell 2 it would chage the cell informtion. From YES,NO,YES,YES to NO,NO,YES,YES. Normal stuff like that.

If anyone can help me ill name my first Child after you. Thanks for your time