Adding within a cell

[benmmaddog]

hello, what I'm wanting to do is say i have 10 in a cell and i what to add 5 to it , i don't want to erase the 10 and type in 15, i want to be able to either just type in a 5 in that cell or put 5 in a adjacent cell and 15 will be shown in the original cell . its like a running total cause the next time say i want to add like 20 i want the the original cell to show 35 . i hope that makes sense. its like an inventory. i metal detect so i want to keep a running total of the coins i find.

 

[Jonmo1]

Welcome to the board..
You'll need VBA code for that..

Right click on the sheet's Tab, View code
Paste the following

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$B$1" Then Range("A1").Value = Range("A1").Value + Target.Value
End Sub

That will add the value of B1 to A1 each time B1 changes.


Hope that helps.

 

[benmmaddog]

THANK YOU ! Very Much, I knew there had to be a way to do that. Thanks again