Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-17-2017, 06:49 PM
HelicopterChick HelicopterChick is offline Rolling 30 Day Total Windows 8 Rolling 30 Day Total Office 2013
Novice
Rolling 30 Day Total
 
Join Date: Aug 2016
Posts: 4
HelicopterChick is on a distinguished road
Default Rolling 30 Day Total

Currently I use the attached workbook to manage my flight hours. I need to implement a form of fatigue management so I need to start having a rolling 30 day total on my daily flight hours. If you look on the March Tab, I have a SUMIF formula in Column R, Row 38 that totals the hours from Column F for the previous 30 days.



For other days I will need to reference the previous sheet.

My question is: How do I do that?

Any assistance would be greatly appreciated.

Thank you!
Attached Files
File Type: xls 30 Day Running Total TEST Duty Log 2015.xls (172.5 KB, 14 views)
Reply With Quote
  #2  
Old 02-18-2017, 12:22 AM
xor xor is offline Rolling 30 Day Total Windows 10 Rolling 30 Day Total Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

A solution based on reference to a previous sheet seems cumbersome to me. I attach a file where I have shown another possibility in which, by the way, it will be very easy to make a pivot table.
Attached Files
File Type: xls 30 Day Running Total_2.xls (262.5 KB, 22 views)
Reply With Quote
  #3  
Old 02-18-2017, 03:51 PM
NoSparks NoSparks is offline Rolling 30 Day Total Windows 7 64bit Rolling 30 Day Total Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

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.
Attached Files
File Type: xls 30 Day Running Total_VBA.xls (201.5 KB, 8 views)
Reply With Quote
  #4  
Old 02-23-2017, 11:26 AM
HelicopterChick HelicopterChick is offline Rolling 30 Day Total Windows 8 Rolling 30 Day Total Office 2013
Novice
Rolling 30 Day Total
 
Join Date: Aug 2016
Posts: 4
HelicopterChick is on a distinguished road
Default

Aloha Xor & No Sparks!

Thank you, both, for your rapid response! I was up against a deadline so I ended up using a helper sheet which isn't the most effective or logical way but it got the job done. Now that the system was approved I can incorporate a more effective way of getting the same result in order to optimize results in the future. I will definitely look deeper into both angles - Pivot Tables and Macros. Thank you again and have wonderful days!

HelicopterChick
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Rolling 30 Day Total Rolling up monthly results based on weeknum? chollyred Excel 1 08-26-2016 08:20 AM
Rolling 30 Day Total 30 Day Running or Rolling total (Multiple Sheets/Workbooks) HelicopterChick Excel 3 08-23-2016 04:52 AM
Rolling 30 Day Total 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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:18 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft