Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]() 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. Thanks for any help -- joelbeveridge ------------------------------------------------------------------------ joelbeveridge's Profile: http://www.excelforum.com/member.php...o&userid=37045 View this thread: http://www.excelforum.com/showthread...hreadid=567717 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro question | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |