Man, I hope this is straighforward.

If I am in cell D4, how can I change the contents of cell B6 (for example).

My issue is this. In cell D4, I want to check for a specific value in B6. If that value exists (TRUE) then I want to move the contents of cell A2 into cell B6. Do I need a macro to do this?

Thanks,

ExProgrammer (mainframe, COBOL, PL/1)