I guess you meen something like "If an record in table 1 is in table2, delete it from table 2, else do nothing". Correct? 2009/9/28 Tweety <wanjirunjoroge@gmail.com>

Ladies & Gentlemen,

I'm looking for a solution, be it a Macro to dedupe 2 tables on MsExcel 2003. One holds like 1000 records which i need matched & removed from the 2nd table of 10,000 plus odd records. Vlookup & Advanced filter haven't lived up yet. I'm in a situation where downloads are off the option list, Excel's all i have.

-- Believe: - To accomplish great things, we must not only act, but also dream; not only plan, but also believe ----Anatole France _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science: http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi: http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general

-- שִׁמְעוֹן