Try copying all the data from both worksheets to a new single worksheet and
then use the advanced filter to copy the unique records only to a new
location.

In xl2007 click on Data to obtain the correct Ribbon and you will see
Advanced under sort and filter. In earlier versions select
Data-Filter-Advanced Filter and you will see the options to copy to another
location, the box for copy to location and check the unique records box.

Hope this helps.

Regards,

OssieMac


"director59" wrote:

I need a formula to compare two worksheets and create a new spreadsheet
without duplicates and with the new data in it? Can it be done?