Cell Formatting

Burnedout · #1 (**permalink**) 09-04-04, 22:08

When I add Cell C & D together I get a total. I put this total in Cell A.

Is there a way to make Cell A show me an accumulated total for any value added to C or D. The reason for this total is I am trying to create an overtime issuance log based on total hours and I require a grand total for a set period?

Any suggestions would be greatly appreciated.

DavidCoutts · #2 (**permalink**) 09-06-04, 04:34

Im not entirely sure what you want, is this any help

Code:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 3 Or Target.Column = 4 Then
        Range("A" & Target.Row).Value = Range("A" & Target.Row).Value + _
            Cells(Target.Row, Target.Column).Value
    End If
End Sub

Dave

Burnedout · #3 (**permalink**) 09-06-04, 20:58

Thank you David, your soultions worked prefectly.

Internet Services

Web Development

Digital Marketing

Consumer Tech