I've taken a stab at this...
The same region that was grouped had the first cell merged over the same range so I used the 'mergecells' property instead of grouping. I have a sheet which is named "Gantt" and the code uses the bubble-sort method and a copied sheet to pull data from:
It's really slow maybe because of how 'mechanical' it is.... sort out the start date, shuffle the start and end points according to the start date, copy the data source, make a copy and delete the original range and then paste in the data according to the sorted startdate array.
Maybe this gives a better picture of the tool? Is there a better way to accomplish this do you think?
Bookmarks