Macro to insert copy of row if Open dates are less than Closed dates

1. if value in column I is 'Maintanance', (n.b. we will call row the 'Maintanance row) then check if the 'Ticket Open' dates for the next rows are less than 'Ticket Closed' for the 'Maintanance' row
2. Insert a copy of the 'Maintanance row after the last row whose 'Ticket Open' is less than the 'Ticket Closed' for the 'Maintanance' row
3. 'Ticket Open' and 'Ticket Closed' for the inserted row should be the same as the 'Ticket Closed' for the 'Maintanance' row
4. then look for the next Maintanance row in column I and repeat same procedure


I have attached the file with row I had to insert manually after a macro I created failed. The original file has more than 500 Maintanance rows.

The Maintanance row is in row 6. I inserted a copy of the 'Maintanance' row in row 10.


Please assist. I have been working on this file since last week.

Hi.

This is exactly what I wanted. Sorry for the late response. I haven't been well and was offline. Thank you so much.