Results 1 to 3 of 3

Thread: Cell Formatting

  1. #1
    Join Date
    Aug 2004
    Location
    Aurora, Ontario
    Posts
    10

    Question Unanswered: Cell Formatting

    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.

  2. #2
    Join Date
    Jan 2004
    Location
    Aberdeen, Scotland
    Posts
    1,067
    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

  3. #3
    Join Date
    Aug 2004
    Location
    Aurora, Ontario
    Posts
    10

    Thumbs up

    Thank you David, your soultions worked prefectly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •