Cell History Log

[gandolff]

Hi all,


OK, here's the deal... I have a formulaic value in A1, which will regularly change. However, I need the immediately prior value of A1 to appear in J15.

For instance, if A1's value at 1PM is "5" and at 2PM changes to "6", I need "5" to get recorded in J15, and so on... Seems simple enough, any ideas?


Thank ya,
G

P.S. Any macros would need to be "triggerable" via formula-induced value changes, not direct/manual cell input.

[DonkeyOte]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.