T
Tdp
Hi,
I have the following in sheet1
Cell J3= Todays date
Cell F8= Hours flown in one flight on that date
Cell H8= Cumulative total for the day
Cell C8= Cumulative total for the year
I do the above with the following code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not Intersect(Target, Range("F8")) Is Nothing Then
Range("I8") = Range("F8") + Range("I8")
End If
If Not Intersect(Target, Range("F8")) Is Nothing Then
Range("C8") = Range("F8") + Range("C8")
End If
End Sub
That works well.
What I need to do now (if possible!!!!) is to be able (on a separate sheet)
to record a running total for each day of each month of the year. Can that be
done by just entering the daily hours in the cells in sheet1?
I have the following in sheet1
Cell J3= Todays date
Cell F8= Hours flown in one flight on that date
Cell H8= Cumulative total for the day
Cell C8= Cumulative total for the year
I do the above with the following code:
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not Intersect(Target, Range("F8")) Is Nothing Then
Range("I8") = Range("F8") + Range("I8")
End If
If Not Intersect(Target, Range("F8")) Is Nothing Then
Range("C8") = Range("F8") + Range("C8")
End If
End Sub
That works well.
What I need to do now (if possible!!!!) is to be able (on a separate sheet)
to record a running total for each day of each month of the year. Can that be
done by just entering the daily hours in the cells in sheet1?