Hi All,
I am trying to create a 'calendar view' based on a gantt chart. I'm struggling with taking the first and last cell of the date range and merging those cells and all inbetween. Additionally, Ideally the contents of the 1st cell should be contents of the complete merged cells.
I've also added conditional formatting which determines the start date and end date and creates the range of filled cells. Plus will color code the bars based on service type.
Would appreciate any help anyone can provide?
JayJacko
Bookmarks