Hey People. 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


--
joelbeveridge
------------------------------------------------------------------------
joelbeveridge's Profile: http://www.excelforum.com/member.php...o&userid=37045
View this thread: http://www.excelforum.com/showthread...hreadid=567709