Remove duplicates from 2nd list

**skins** · 06-01-2011, 07:58 AM

Hello

I wonder if someone would be able to assist me. ive tried googling it but as yet havent found anything that works and my brain is literally starting to melt

please be aware my excel knowledge is very basic ive literally just started using it so could do with step by step assistance if possible! Heres what im trying to do:

I have two lists obtained from different sources. the master list contains rows of people (sheet 1) that i have already contacted. On a weekly basis i have another list of rows in a 2nd list (sheet 2) that i want to compare against the 1st list and remove any duplicates from the 2nd list so they are not contacted again.

Any idea of how i can easily do this?

Thanks in advance!!!

**111StepsAhead** · 06-01-2011, 08:05 AM

Combine both lists together and run the following code in your program.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=135

**skins** · 06-01-2011, 09:24 AM

i need the first list intact tho?

**skins** · 06-01-2011, 09:25 AM

Originally Posted by 111StepsAhead

Combine both lists together and run the following code in your program.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=135

i need the first list intact tho?

**watersev** · 06-01-2011, 08:12 AM

hi, skins, please post sample workbook

**skins** · 06-01-2011, 08:38 AM

Originally Posted by watersev

hi, skins, please post sample workbook

please see attached. so using this as an example i would be looking for sheet 2 to be left with only the sarahs, hope this makes sense.

Thanks again for help.