Hi Megan

no "automatic" way that i know of, but you might like to have a read of
http://www.cpearson.com/excel/duplicat.htm
Chip's got lots of ideas there on dealing with duplicates.

Cheers
julieD

"Megan" wrote in message
...
Is there a way to merge to large spreadsheets together so that it will
automatically remove the duplicates so that only one of the same enteries
remain? Thank you for your help!