I guess you meen something like "If an record in table 1 is in table2, delete it from table 2, else do nothing". Correct?
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