How to compare columns in 2 sheets then delete if no match

[needtoknowasu]

Hello,
1st Sheet "KEY"
2nd sheet "Sheet3"

1) Go through Col E in "Sheet3" (rows can vary in length) don't want to hardcode. Plus headers exist in row 1
2) compare to "KEY" Col A. (no header in this sheet)
3) If no match then delete row in "Sheet3"

How do I go about writing the code?
Just stumped how to go about this.

Thanks,
asu

[mehmetcik]

I assume column F of Sheet 3 is empty

In which case this macro would help.

Please Login or Register  to view this content.

I added some error checking:-

Please Login or Register  to view this content.

[needtoknowasu]

On "Sheet3" Col A-F are occupied with data.

Since code is running through Col E I noticed it cleared contents of Col F.

How do I keep COl F data intact?

Looks like matching & deleting rows is working but need COL F to stay intact.

Thanks,
asu

[mehmetcik]

Please Login or Register  to view this content.

[needtoknowasu]

Thank you so much!!

I changed the [-5] to [-6]

You saved me hours if not days trying to figure this out.

Thanks,
asu

[needtoknowasu]

I just noticed that it was not matching all data.

Is there a way I can attach sample file .xslm without exceeding size? My file exceeds the attachment size 240KB

Thanks,
asu

[jolivanes]

Assumes that Column J in Sheet3 is empty.

Please Login or Register  to view this content.

If you want to attach a file that is too big, make it smaller!