Using weekly data to convert to monthly

And how do you want to split data referring to a week that's part of different months?

Ahh good point. Is that something that would be easy to do? I know it would mean the weekly 'input' sheets would need a date column but suppose it would take an overhaul of the weekly and monthly totals sheet?

It's not crucial that they are separated that finely. If a date is w/c 26/7/2010 then putting it in July would be ok. As jobs can be accepted weeks after the initial quote I realise there is always going to be some sort of 'lag'.

We use the sheet to primarily see seasonal trends in workload coming in over the year and to judge marketing impact.

Yes that looks great JBeaucaire, thanks

I should be able to use that formulae to populate the rest of it.

Just as a side note, in your (more expert than mine) opinion, is this the best way to record what I am doing?

It is usable and easy enough to maintain. Although I have no comparison so this way is all I know.

Feel free to re-design it if you find yourself with a bit of free time!

Thanks for the code/formula

I've just noticed, the stuff you have done doesn't quite match up with the months. The 2 rows that have populated are matched to November and December rather than June and July and there is no data for August or September?

Thanks mate. I did it that way just to note the start of the system. Kind of like the beginning of a financial or tax year!