adding on to an existing total & avoiding a circular reference blo

[Guest]

I would like to have a cell with a growing total,that will automatically
increase when another amount is entered into another cell, but I keep getting
a block from the "circular reference'?eg if A1 =$50 & I enter $5 in to A2,I
would like A1 to automatically grow to $55?This is no different to the "check
out " chicks at the grocery store cash register adding groceries to a growing
total.

 

[Guest]

Rightclick on sheet tab and insert this :

Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A2")) Is Nothing Then Exit Sub
[A1] = [A1] + [A2]
End Sub



"bukti" skrev: