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?

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?

I guess I should explain what I am trying to do. I pull a report every day of
the week of the same type of data. I need to find the new and deleted record
between the two days. I have tried the filter, but unless I am doing
something wrong, it doesn't give me both.

"OssieMac" wrote:

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?