Macro to Merge Sequential Dates in Rows

Thanks Richard, I should have mentioned that in my original post.

If there is a non-sequential Start/End Date within the same title, then do option c:

c) merge the rows up to the break and continue in the same title looking for further matches

If there are no sequential Start/End Dates within a title, then the macro moves on to the next title.

If there are sequential Start/End Dates within a title, but the rights do not match in any one of the three columns, then do not merge, but continue to look for further matches within the title.

Thanks for asking the question.