creating a running inventory

[Robert C.]

I want to be able to enter a nuber in G3 and have it add to the number already in H3. Then when I enter a new number in G3, I want it to overwrite and accumulate in H3. Any help would be greatly appreciated. I have attached a copy of the file.

[ChemistB]

You'll need VBA
Right click on the sheet tab and "View Code"
Paste this code into the VBA Editor and then close it.

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 7 Then
    Target.Offset(0, 1) = Target.Offset(0, 1) + Target
End If

End Sub

Is that what you were looking for?

[Robert C.]

That is exactly what I've been trying to do. Thank you so much. I've been going nuts trying to figure it out.