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 hav
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 Cel
"A" - (and so on).

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

If anyone can help me ill name my first Child after you. Thanks fo
your tim

--
joelbeveridg
-----------------------------------------------------------------------
joelbeveridge's Profile: http://www.excelforum.com/member.php...fo&userid=3704
View this thread: http://www.excelforum.com/showthread.php?threadid=56772