I do not think it is just a recalculate issue! When you enter a new figure in the next empty cell in column "A", a value automatically appears in the empty cell in column "B" and is based on the formula in the previous row of column "B". Some times I can copy a "B" cell that works, modify the formula and replicate it in column "C". Sometime column "C" reacts to the Column "A" entry. Is there a name for this feature? Is it possible there is a hidden macro; if so how is it activated? TIA JP
|