Finding and deleting a small list of names from a really big list of names

**vitalstatistix** · 07-06-2011, 12:01 PM

Ok, So say for example the first list, from A1:A99 is my list of 100,000 names.

The second list, A101:A117, represents the 600 names that I need to remove from the first list. I want to delete the entire row that the name appears in.

Is there a way to make the filter automatically do this? I don't really want to find and click off 600 names in a list of 100,000.

Thank You!

**Charles** · 07-06-2011, 01:34 PM

HI,

Thanks for the workbook, however you are showing all of the data in column "A". Is that the way your actual data is laid out. The List of names you want to compare is in column A, but where are the names you want too remove ? Are they in the same workbook? And too i'm looking at doing this via code.

**vitalstatistix** · 07-06-2011, 02:10 PM

The second list can be placed anywhere. It is an independent list of names I need to remove from the original list It might make more sense to place it in a different worksheet. If I placed it in a different column I wouldn't be able to delete the entire rows though.

Hopefully someone can help us out!

Cheers,
V