VBA Calculation to add two Columns together

Hi there,

I'm looking for some VBA code to help me add two cells in two columns together which look like this:

Current Week Hours | Total Week Hours
4                               |   10
8                               |   14
9                               |   13
9                               |   18
6                               |   19

What happens is the user enters the data in current week hours and it should update total with the correct addition. Meaning for row 1, when I enter 4 in Current , Total should then be updated to 14. I tried with Excel and got nowhere (circular blah blah blah).

There are about 70 rows that have this so it needs to be a loop, and there are some empty cells in both columns which can be safely ignored.

I've been trying to copy and paste pieces of vb code together to try and reach my end goal, I just started with excel and vb this week so I'm completely noob!
Start Free Trial

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:

Private Sub SumVis(ByVal Target As Range, Target1 As Range)
    Dim Total As Range
    Dim Current As Range
    Dim TTotal As Integer
    
    Set Current = Intersect([K8:K70], Target)
    Set Total = Intersect([L8:L70], Target1)
    
    'If Current Is Nothing Then Exit Sub
    
    Application.Volatile True 'Everytime a cell changes a calculation is made
    For Each cel In Current.Cells
        If cel = "" Then
           
        Else
            TTotal = cel + cel.Offset(0, 1)
            Cells(Target1.Row, "L") = TTotal
            SumVis = TTotal
        End If
    Next
     
End Sub