Use another cell to permanently change value of another cell

[Payupright]

Hey there, I am not sure if this is even possible, but I am basically trying to make a calculator of sorts. I would like to be able to enter a value into I3 and add/subtract it from C3, but I would then like for C3 to remain that new value and I3 be reset to 0 without removing the previous value from C3 (So a simple SUM won't work here as it does not cause a permanent change to another cell). Again, I am not sure if this is even possible, or if what I am wanting to do makes much sense.

Any assistance is greatly appreciated

 

[Snakehips]

@Payupright You will need to use vba to achieve the above.

Assuming that you will enter negative values to ahieve subtraction then this simple Worksheet _Change event should do it.

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count > 1 Then Exit Sub
If Not (IsNumeric(Target) And IsNumeric(Range("C3"))) Then Exit Sub
If Not Intersect(Target, Range("I3")) Is Nothing Then
Application.EnableEvents = False
    Range("C3") = Range("C3") + Target
    Target = ""
    Target.Select
Application.EnableEvents = True
End If

End Sub

Paste it into the code module of the relevant sheet.

Hope that helps.