|
|
#4
02-18-2017, 03:51 PM
|
|||
|
|||
If a VBA macro solution interests you...
Here's one that will calculate the 30 day total when the flight hours is entered in column F. Assumptions are that the 12 monthly sheets are the only sheets in the workbook, the sheets are in order, and the cell in column A immediately after the last day of the month is blank. Some of yours were blank and some had spaces in them. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Rolling up monthly results based on weeknum?
|
chollyred | Excel | 1 | 08-26-2016 08:20 AM |
|
30 Day Running or Rolling total (Multiple Sheets/Workbooks)
|
HelicopterChick | Excel | 3 | 08-23-2016 04:52 AM |
|
30 Shift Rolling Average
|
tandchas | Excel | 7 | 07-02-2014 12:56 AM |
| Coordinate rolling text in a webinar | ar8294 | PowerPoint | 1 | 11-28-2012 12:55 AM |
| Data From One Slide Rolling Up To Another | Kdubb4410 | PowerPoint | 0 | 07-28-2010 11:28 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode