How can I make it so that if I enter anything into cell range B3:E3 the value will be whatever I input, plus the value of the above cell.
example: If I input 20 into cell C3, once I hit return or click away the value will be updated to 40.
So far I know I need to have something similar to this:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("B3:E3").Value = Range("B2:E2").Value End Sub
And I know I need to somehow access the offset value, but VBA is not my forte and I cant seem to word this question correctly.