Hi there,

First post, and I am afraid it is pretty complicated. We have two work sheets (lets call them Work1 and Work2), in column A in both is a time, in B is another time and in C a unit value.

Work2 will have the same rows as Work1, but Work1 will have additional columns. to make it a bit easier
Work1 Work2
9:00 10:00 1 9:00 10:00 1
10:00 11:00 1 10:00 11:00 1
11:00 12:00 2 12:00 15:00 3
12:00 15:00 3 9:00 10:00 4
9:00 10:00 4

I want to compare the three cells in both worksheets and in Work2 add an extra row where they do not match to get them in line: e.g.

Work1 Work2
9:00 10:00 1 9:00 10:00 1
10:00 11:00 1 10:00 11:00 1
11:00 12:00 2
12:00 15:00 3 12:00 15:00 3
9:00 10:00 4 9:00 10:00 4

Sometimes there will be multiple spaces that will be needed, Sorry this is a hard one!

Thank you!