I have to monitor the amount of manhours used at suppliers.

Row A is the month
Row B is the week ending date
Row C onwards is the manhours that the supplier has used.


October November This Month Cumulative Year
1 15 22 29 5 12 19 26 November To Date To Date
10 10 10 10 10 10 10 10 40 80 440
5 5 5 5 5 5 5 5 20 40 220

What want to do is report the manhours weekly in a report and the month to
date.

The figures that are reported are
1) the manhours for the month that is ending,
2) the cumulative manhours for that particular month
3) the year to date.

Is there a macro to do this so that for any particular month the figures
are entered into the report .

Many thanks in advance