Macro for Comparison

[sarajun_88]

I have a macro that compares the datas in column A and B of the sheets 'Patches' and 'NA' and deletes the data in the 'Patch' sheet that matches with the ones in the 'NA' sheet.

It works perfect except for one issue. There is a patch ,

'Must Upgrade Product SP Before Applying Patch' in the 'Patches' sheet for a lot of machines whereas the same patch is present for only on machine (D) in the 'NA' sheet (Marked in Red).

when i run the macro all the 'Must Upgrade Product SP Before Applying Patch' is deleted in the 'patches' sheet whereas it must be deleted only for the machine D.

Please Login or Register  to view this content.

can any one please help me on this? Thanks in advance!!

[Marc L]

Must respect forum rules : code tags ‼

[sarajun_88]

Sorry!! Edited as per the rule

[pbengtss]

How about this instead?

Please Login or Register  to view this content.

[sarajun_88]

Sorry!! this didn't work the way I wanted

Thank You!

[pbengtss]

It would help me to help you if you explained what the problem is...

[sarajun_88]

The macro needs to compare the datas in column A and B of the sheets 'Patches' and 'NA' and deletes the data in the 'Patch' sheet that matches with the ones in the 'NA' sheet.
It should loop with data in the 'patches' sheet with the ones in the 'NA' sheet.
There are multiple patches (column B) for the same server (Column A). so i want to check whether a server and its patches list in NA sheet matches if so it has to be deleted in the patches sheet.
I have saved the result data which i want in the 'Result' for your reference.

Please Login or Register  to view this content.

this code works but it doesn't work for the patch ''Must Upgrade Product SP Before Applying Patch' alone. I have marked the patch in red.

[pbengtss]

1) I'm not sure that I'm following - columns A and B should match? But you only check column B?

2) I also made an ugly mistake! Instead of

Please Login or Register  to view this content.

I had

Please Login or Register  to view this content.