- Registration date
- Sunday April 12, 2009
- Last seen
- February 16, 2010
You would rather to put conditions in your Sheet A to D , while input sheet update ...
Suppose your Sheet1!A1 = 1 or 2 then in your Sheet A & B cells A1 must have this condition
Sheet A & C : A1=IF(input!A1=1,"Yes option one is clicked","")
Sheet B & D : A1= IF(input!A1=2,"Yes option TWO is clicked","")
Hope it will make some sense to you ......