Storing previous value in cell when data is changed

Hi,

I have a value in A1 that continuously changes. However, after A1 has changed, I need the previous value in A1 to appear in A2 and when A1 changes again, I again need the previous value to appear in A2 and so on.

For example, if A1=1 and it changes to A1=2, then I need A2=1. Then, if A1=3, I need A2=2, etc.

I simply need the previous value in a particular cell to be stored in another cell. If somebody can help me with this problem it would be greatly appreciated.

Can I build the function by storing the previous value someplace on the worksheet or in another hidden worksheet? The problem is that I can't save the value in the memory after the function stops.

It changes because you're changing it, or as a result of a formula, or something else?

what really happens is E53 is a user-entered value. then, because of that value, E56 changes due to the formula written in E56. Now after I change E53 to another value, I need the previous value of E56 to be stored in P56. SO i need the previous value of E56 to be stored in P56 (again E56 changes as the user-entered E53 changes). Any ideas? Any help would be greatly appreciated. I really have no idea how to use VBA =(

thanks. i believe it actually is working. however when E56 changes, the adjacent cell is the previous value of E56 for only a few seconds and then it changes to the current value of E56. I'm unsure why this is. if you could help that would be great. Thanks for all the help already.