Formula ? SUM of 2 cells

[cripopes]

Hello folks,

First of all please excuse my lack of excel knowledge, the following question might seem a bit nooby for you but I'm at my first steps here.

What I'm trying to do is SUM of cell 1 into cell 2 - cell 1 will be constantly changing every day and that input amount to be added into cell 2.

For example, I want cell B3 to be added to D3, which will be 278. So basically the input number of B3 to be added into D3. The original value of D3 will not be blank, it will be an input number.

 

[maabadi]

If I correct understand when you modify cell C3 then if C3 = 4 & D3 = 229
D3=D3-C3 & D3= 225
Is this correct?

 

[cripopes]

Private Sub Worksheet_Change(ByVal Target As Range)
Dim newVal As Long, oldVal As Long
    If Target.Column = 2 Then
        'new val
        newVal = Target.Value
        Application.EnableEvents = False
        Application.Undo
         oldVal = Range("D" & Target.Row).Value
        Range("D" & Target.Row).Value = oldVal + newVal
        Target.Value = newVal
        Application.EnableEvents = True
    End If
    If Target.Column = 3 Then
        'new val
        newVal = Target.Value
        Application.EnableEvents = False
        Application.Undo
         oldVal = Range("D" & Target.Row).Value
        Range("D" & Target.Row).Value = oldVal - newVal
        Target.Value = newVal
        Application.EnableEvents = True
    End If
End Sub

This seems to work. Thanks a million, sir.

 

[maabadi]

You're Welcome & Glad you can sort it.