If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Recording changes in cell value
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. |
#3
|
|||
|
|||
Recording changes in cell value
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. |
Thread Tools | |
Display Modes | |
|
|