VBA Macro to Insert New row/s based on two dates

[chinraj]

Hi,

I need to insert blank row/s between the missing dates and fill the missing date & corresponding employees name. Let me explain in detail,
I have a start date in Cell E1 and end date in Cell G1. Need a macro to verify the date range in Col A with these start & end dates and insert blank row for missing date corresponding to employee names in Col B. This should be repeat till last used row of the sheet. Attached sample(Before&After) workbook.

PS: Both missing date and respective names to be filled in the newly inserted rows.

Any response/suggestion will be greatly appreciated!

Thanks,
Chinraj

[arlu1201]

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.

[chinraj]

Yes. This is solved with help of Bernie Deitrick. Please note that both posts are little different case.

http://www.excelforum.com/excel-prog...ml#post3707350

Thanks!