A simple way w/o macros is to create a new column with an "if formula"
that does a "vlookup." If the vlookup matches then return "Duplicate"
else return "". Then copy/pastespecial (value) the new column and sort
the data by the new column in descending order.

So for you, insert a column "C" in your "original work database" then
in the new column all the way down:

=IF(ISERROR(VLOOKUP(B1,[output]output!$S:$S,1,FALSE))=FALSE,"DUP","")


--
Ikaabod
------------------------------------------------------------------------
Ikaabod's Profile: http://www.excelforum.com/member.php...o&userid=33371
View this thread: http://www.excelforum.com/showthread...hreadid=535002