Insert Cells and Dates

[turtle615]

Hi all,

New guy here and just getting started using VBA. I am working on something for my company's timesheets and have run into an issue. I have column A with Employee Name, column B with Timesheet Submitted Date, and column C with start date of the timesheet. If a person creates a timesheet, but doesn't submit it, it only has a date in the Start Date column. If they have created and submitted, they have dates in both, and if they have not created it, it has zero data. Please see attachment.

What I am looking to do is write a VBA so that there will be blank rows inserted in between dates where they did not submit a timesheet. For example, there is no timesheet between 4/1 and 4/6, i would need 4 blank rows inserted.

As I stated, I am completely new to this. Just looking to get some instruction on how to move forward as I am completely lost.

Thank you,