Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cumulative total??????
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? -- Tdp |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
cumulative total | Excel Discussion (Misc queries) | |||
cumulative total | Excel Discussion (Misc queries) | |||
cumulative total | New Users to Excel | |||
cumulative total | Excel Worksheet Functions | |||
Cumulative Total | Excel Discussion (Misc queries) |