Delete row comparing 2 columns

[pezalmendra]

Hi!

Hope someone can help me with the code Im looking for...

I need a macro that compares data from 2 columns (D7 till the end & E7 till the end) and when it finds that data from one cell in column D is the same than in column E (looking always in the same row), then delete that row.

I cannot find a code to compare in that range cause there are many cells that are empty and so, its not necessary to delete the row cause there is nothing on it.

Thanks in advance!!

Regards

[mike7952]

Can you upload a sample of the workbook?

[pezalmendra]

Hello!

I herewith attach the file. What Im looking for is that:

If time in column D = time in column E
Then
Delete that row


Thanks!!

[mike7952]

Give this a try

Please Login or Register  to view this content.

[pezalmendra]

Thats perfect Mike!!!

Thanks a lot!!!

Regards,