Merge cells based on Month Number within Date value in cells

[jsavoor]

Hi

I need to do a roadmap and want to automate the Month cells but also make them look presentable. I have a range of cells with dates based on weekly periods (date(now), date(now)+7, etc) These are in ROW 2 and begin in COL B.
I want to show the month in ROW 3 but I would like to have a VB script that will first UNMERGE the entire row, and then merge the cells corresponding to the month in ROW 2. The VB Script should also enter the MONTH name centered within the merged cell.

So...

1	b	c	d	e	f
2	20/07/2012	27/07/2012	03/08/2012	10/08/2012	17/08/2012
3	JU	LY		AUGUST

<tbody>
</tbody>

Result shows that B3 and C3 are merged and say JULY centred, and cells D3, E3 and F3 are merged with AUGUST centered in.

I would be most grateful if someone could please help me.

Thanks and warm regards

Jay

 

[jsavoor]

Hi

Can anyone help me with this??

Thanks

Jay