compare two lists - delete from second items that are not on first

[ajaykgarg]

I have a master list, and a detail list.
From detail list, I want to delete items that are not on master list.
i am using below code.

Please Login or Register  to view this content.

Is there a faster way to achieve this?

Thanks
Ajay

[MarvinP]

Hi Ajay,

Why not create a Helper column on the detail sheet that does a Match of the list on the Master. It will come back with either a number, showing it is on the master; or an error in that helper column.
Then you can only deal with a single detail sheet and remove rows where the helper column is an error. I think that would be much quicker than your above.

[bakerman2]

Or you can make use of dictionaries.

https://www.excelforum.com/excel-pro...ml#post4693781

[ajaykgarg]

Thanks for your inputs.
I found

Please Login or Register  to view this content.

to be fastest of all options I tried to populate helper column.