Hi,

Using Excel 2010 and fairly experienced using macros

Looking for some help in splitting monthly forecast into weekly buckets, data could be horizontal or vertical (most cases it will be horizontal)

2nd Mar 2015 6th April 2015 4th May 2015 etc.
120 120 240 etc.

Ideal result would be

2nd March 9th March 16th March 23rd March 30th March etc.
20 20 20 20 20 etc.

On occasion there may be a customer who prefers it to be monthly and the forecast received would be in quarterly buckets.

Any help will be greatly appreciated

Thanks
Raymond