Help with a cell referencing itself in a formula

[Scipo0419]

First time posting and tried searching but couldn't find exactly what I'm looking for.

I'm working on a spreadsheet for work where I have current hours and cumulative hours. Is there a way I could have the Cumulative Hours, add the current hours through VBA?

Basically I need:

---

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD]Current[/TD]
[TD]Cumulative = Cumulative + Current[/TD]
[/TR]
</tbody>[/TABLE]

---

Where every time I change the "Current" hours total the Cumulative updates accordingly. This will go down an entire column. I'm not sure if this is possible, but adding it manually increases the chances of errors and I'd like to minimize that as much as possible. Currently our Cumulative looks very similar to: "=80+90+75+85+75.5+95.5+90+80+65...."

 

[wideboydixon]

Assuming "Current" is column A and "Cumulative" is column B then right click the sheet name and select "View Code" from the menu. Paste the following:

Private Const CurrentColumn = "A:A" ' Change as necessary
Private Sub Worksheet_Change(ByVal Target As Range)

Dim changedRange As Range
Dim changedCell As Range

Set changedRange = Application.Intersect(Target, Range(CurrentColumn))
If changedRange Is Nothing Then Exit Sub
For Each changedCell In changedRange
    changedCell.Offset(0, 1).Value = changedCell.Offset(0, 1).Value + changedCell.Value
Next changedCell

End Sub

You can change the "Current" column by changing "A:A" on the first line.

WBD