Recording changes in cell value

Hi,

I want to record any change in value of cell A in B; i.e. if I have a
number in cell a which is increase by 2 I want 2 recorded in cell B and
continue to add any future change to cell A.

On Sep 18, 2:46 pm, CDC wrote:
Hi,

I want to record any change in value of cell A in B; i.e. if I have a
number in cell a which is increase by 2 I want 2 recorded in cell B and
continue to add any future change to cell A.

If I'm reading your request properly, you can't easily do this. There
is a function in morefunc that can do this, otherwise someone could
possibly write another UDF. Do a search at download.com for morefunc.

The morefunc function is RECALL, and it would be used like this:
=RECALL(TRUE)+A1

That formula will return a running total of the values typed into A1.
Or calculated by formula in A1. RECALL will not list the values, just
show the total.

This can be done but is fraught with danger.

There will be no "paper trail" for error-checking and no way to recover from
errors without starting over.

See John McGimpsey's site for methods.

http://www.mcgimpsey.com/excel/accumulator.html


Gord Dibben MS Excel MVP

On Thu, 18 Sep 2008 12:46:01 -0700, CDC
wrote:

Hi,

I want to record any change in value of cell A in B; i.e. if I have a
number in cell a which is increase by 2 I want 2 recorded in cell B and
continue to add any future change to cell A.