Copy rows based on cell value, with loop

Hi,

I have some sample data where columns F & G hold Start Date & End Date, eg, 11/01/2021 in column F and 13/11/2021 in column G.
Taking those dates, I'd need the entire row to be duplicated until the start date is the same as the end date. So I'd end up with 3 rows of data with everything the same, except the start and end date.

This is how the data starts:
excel1.JPG

The result would be like this (ignore the colours, they are there to try and make it appear more simple as to what is happening)
ezcdl2.JPG

So in the above, the yellow row has been duplicated 3 times as the start date (11/01/2021) and end date (13/11/2021) difference is three full days. On the newly created rows, both the start and end date show the individual date.

I've also attached the sample file if that helps.

Any ideas would be greatly appricated. I know I need a loop or two to cycle through the original list, and subtract the start date from the end date to get the duration, but after that I'm not sure how to duplicate the row X number of times and then change the start and end date.

Huge thanks :D

Try this:

Please Login or Register  to view this content.

Ahh, apologies, yep I meant 28/01/2021 - 28/01/2021

Originally Posted by Akuini

Try this:

Please Login or Register  to view this content.

Oooh that works perfectly, thanks for your help! :D

You're welcome, glad to help & thanks for the feedback.

Originally Posted by Akuini

You're welcome, glad to help & thanks for the feedback.

Hi again, sorry to be a pain but if you have a minute spare could you please explain what/how the code is working. I'm trying to understand it so I can better my own skills but struggling to follow what it's doing
Thanks again and no worries if you don't have time to explain

Sorry, it's hard for me to explain it in writing, harder than writing the code...