I am working on a workbook (2007 version) to keep track of aircraft flight hours each month during the year. As hours are built up each month they will deduct from the monthy and remaining yearly hours for that particular aircraft. At the end of each month I need the remaining FY 13 hours to automatically transfer to the next worksheet which will represent the next month (each worksheet represents a month) and then continue to deduct as hours are flown for that month.

So what I have so far for sheet 1 (using example below) is =SUM(C2+F2-B2) to reach the total in cell G2.

And for sheet 2 i know to carry over the remaining hours i can use the formula =SUM(Sheet1!G2).

So my question comes to...is there any way to combine the formula used in Sheet 1 and Sheet 2 so I can carry over the remaining hours from the previous month while continuing to deduct hours flown for the current month?

N-Number | Hrs Flown | Roll Over Hrs | Allocated Hrs | Remaining Monthly Hrs | Total FY 13 Hrs | Remaining FY 13 hrs |

N-1234 | 10 | 25.5 | 15.5 | 138 | 128 |

<tbody>

</tbody>

Thank you so much for any help you can provide!

Jos