Storing previous value in cell when data is changed

**sepandb** · 07-17-2008, 02:14 PM

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.

**piyushdabomb** · 07-17-2008, 06:11 PM

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.

**shg** · 07-18-2008, 12:15 AM

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

**royUK** · 07-18-2008, 03:23 AM

Try this

Option Explicit


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Address <> "$A$1" Then Exit Sub
    Dim OldValue
    OldValue = Target.Value
    Target.Offset(0, 1).Value = OldValue
End Sub

**sepandb** · 07-18-2008, 11:54 AM

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 =(