Hi,

I have a sheet with sequential dates in the columns and names on the rows,
at the intersect is a number of hours. It'd like this totaled, on a
seperate sheet by weeks in the columns, names in rows as before. Dead easy,
just sum column B to H (7 of 'um) then copy down for each name. Problem is
when I copy across I get C to I, D to J, etc! There may be a pivot table
approach to thsi but the sheet neesd to be as automatic as possible. Any
ideas?

Thanks,

Jon C