Need to remove multiple unique groups of numbers

[mcredcross]

I am looking for an if then formula that will help me remove groups of data from sheet 1. I added sheet 2 which only has 1 column of unique id's that I want removed from sheet 1. In sheet 1 there could be multple rows that have the id that was found on sheet 2. Does anyone have a formula that can help with this.

Thanks

 

[BrianB]

It seems that you basically need a macro to take each item from your list, "Find" in the other worksheet and delete the row(s) found.

Hopefully you will be able to combine the methods used in my code here here ..

FIND : MULTIPLE MATCHES IN ALL WORKSHEETS
http://www.mrexcel.com/forum/showthread.php?p=2280795

FIND : LOOK UP IN ANOTHER SHEET FROM A LIST
http://www.mrexcel.com/forum/showthread.php?t=144226

 

[Easy-XL Support]

This can be done in Easy-XL in two steps by using matching and tagging.

The following 90 second demo video shows you how to identify (tag) and remove all rows that contain an item that is listed in another sheet.

http://www.easy-xl.com/videos/misc/MatchAndTag