Delete the first 7 days data from column B

[irfanparbatani]

Hi friends

I have the below code which paste all the data in file 1 after comparison of 2 sheets, now I need is to check the date range from B1 and also range R, if the top range is within 7 days of date range delete the rows till 7th day and the new 7th day range is copied at the bottom of file 1 sheet1.

Please Login or Register  to view this content.

Thanks in advance