Fix Gaps in Dates

Hello,

I have the attached report which shows begin and end dates in column I and J however there are gaps in dates when you look at the lines for the same person (DBA column) in the rows below. I am trying to see if there is a quick way to have a macro insert a line between each row that has a gap and fixing the gap issue with the new row. It would also have to do this by Co in column A so that when the Co changes the macro starts fresh with the date gap test. Thanks in advance!

Hi
Your attached file does not display what the data should look like after a macro

From you explanation it is not very clear

Sorry. An example would be inserting a row between row 2 and 3 where all of the cells are duplicated with exception of the begin and end dates in column I and J where I would be 12/2/2017 and J would be through 4/29/2018.

unfortunately that is not an option for what is needed. I need the existing lines to remain unchanged and add additional lines to resolve the gap issues.

That is working however the begin date on the new line needs to be the day after the end date on the previous line and the gross amount in column N on the new line needs to be zero. Is that an easy modification? Thanks so much. It worked in seconds too.

you are the bomb xladept. Thanks so much. It worked like a charm.