Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tdp Tdp is offline
external usenet poster
 
Posts: 74
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
cumulative total T McShu Excel Discussion (Misc queries) 0 December 8th 08 06:45 PM
cumulative total George Excel Discussion (Misc queries) 4 October 27th 06 02:20 PM
cumulative total dfisherkern New Users to Excel 1 February 17th 06 05:14 AM
cumulative total darkbearpooh1 Excel Worksheet Functions 7 January 27th 06 05:47 PM
Cumulative Total RockyMountains Excel Discussion (Misc queries) 9 January 12th 05 11:03 AM


All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"