VBA Code to make two columns with dates the same

Hi there,

I attach the file I'm working with. It contains two columns with dates and I want to make them containing exactly the same values. For example, A22 = 01/02/2005 while there is no such date in column B. Hence, I want to delete this so 02/02/2005 comes up and it is equal to cell B22. Then it continues and we have a cell in column A with the date 14/03/2005 but it corresponds with 11/03/2005 on the same row in column B, therefore the cell in column B must be deleted until the two get equal and so on. I wrote the following code:

Please Login or Register  to view this content.

and it runs through the observations up to the beginning of 2006 when it can't go any further. I would greatly appreciate any suggestions on your side. Thank you! Dates.xlsx

Probably not the most efficient but i am sleepy and it is what comes to the top of my mind:

Please Login or Register  to view this content.

Hi n_ant,
try it

Please Login or Register  to view this content.

Thank you all for your suggestions! That's awesome. Words can't express my gratitude