How to group columns based on date with VBA?

[nath1989]

So I have this worksheet for tracking the status of several projects over time (like a gantt chart but not exactly one) and I think it would be better for visualization if the columns were automatically grouped together based on month/year, since there's a lot of columns. I'm struggling to figure out a code for this, my worksheet looks something like this:

and the date columns should be grouped by month and year.

I'd be really grateful if someone could help me with this!

Tks

 

[alansidman]

What do you mean by grouped by month and year. That is a vague term. Suggest you post a mocked up solution so we can be sure of what you want. Additionally, we cannot manipulate data in a picture. Suggest you use XL2BB function.