When the data in a cell changes, automatically take a record of data

[Zipping2010]

Hi All,

I am not sure how to go about creating a spreadsheet that does this:

I wish to create my spreadsheet to automatically make a record of this change value and populate it on Sheet2, so ultimately, I have a full history of how this number changes during the course of time in a row.


I would like any figure in Column R that is greater than 0 to go in column B on Sheet2 on the same row number. Also, I'd like the number in Column C on Sheet1 to be copied to the same row in Column A on Sheet2.

I hope this makes sense. For example, Sheet1 C6 = 7 and R6 = 10. I'd like that to be copied in Sheet2 in Columns A and B in row 6. If the value of R6 changes then it moves into B6 of Sheet2 and the number 10 moves in C6 of Sheet2.

Cheers,

Andrew

[Richard Buttrey]

What causes the figures to change?
Are they formulae in the cells that change because a precedent cell changes or are you changing them manually?

[rodgerzhang]

I have exactly the same question, the cell value will be changed manually, meaning whenever someone changes that cell's value, I would like to keep recording that value in a separate sheet, so a history of change of that cell can be seen.

Thanks.