Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
monthly cumulative worksheets
I am setting up monthly worksheets in same workbook April 08 - March 09.
The data includes Staff extra hours and staff days off sick. For the extra hours, I want each month to reference the total for last month: I can do this manually (using [=]) but I would like a way of doing it once and copying to the other 11 worksheets. For the days off sick, I would like each month to show the cumulative total for the last x months - so June's sheet would show total April + May. Again I can do this manually but is there a quicker way? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rolling Monthly Amounts to Annual Monthly Amounts | Excel Discussion (Misc queries) | |||
How do I set up monthly random work schedule for 60 hours monthly | Excel Discussion (Misc queries) | |||
Need formula for cumulative interest with additional monthly princ | Excel Discussion (Misc queries) | |||
create yearly summary from monthly worksheets | Excel Discussion (Misc queries) | |||
Mortgage template comparing interest pd, monthly, bi-monthly, ext. | Excel Discussion (Misc queries) |