Do you mean that once column C was set to YES by entering 1 in column A, it
should be left unchanged when 2 is entered in column A and reset contents of
only columns D,E,G?

Stefi


€žjoelbeveridge€� ezt Ã*rta:


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


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