VBA for loop and Compare od datas in two different sheets

I have got 2 sheets patch and NA.

I want to compare the data in the 'Patch' sheet with 'NA' and delete the data in the 'Patch' sheet that matches with the ones in the 'NA' sheet.

I have attached the sheets here.

can anyone please help me out in resolving this?

Thanks in advance!

Hi sarajun_88,

Welcome to the forum!!

Try this (initially on a copy of your data as the results cannot be undone if they're not as expected):

Please Login or Register  to view this content.

Regards,

Robert

Hello,

I am in deserate need of a macro that will compare the same column in 2 separate worksheets and then copy in the second sheet only the cells that don't match.
I attached an example. Sheet 1 contains more rows than Sheet 2, and the macro should compare column B in both sheets and then write in Sheet 2 the cells from column B that are not found in the same column B in Sheet2 (in my example Sheet 3 is a representation of how Sheet 2 would look like after executing the macro).

I tried using the info already presented in the forum, but 1 day later I have no satisfactory result.

Can someone help?

Thank you a million!

N

Hi sarajun_88,

Thanks for the feedback and if you could mark thread as solved it would be appreciated.

Hi nicoletanistor,

Please take a moment and re-read rule 2 of our forum rules here that you agreed to when you signed up as posting a question in someone else's thread is in breach of them.

That said and as you're new I have written this for you - this time:

Please Login or Register  to view this content.

Regards,

Robert