How can I compare and filter data in 2 spreadsheets

D

director59

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?
 
O

OssieMac

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
 
D

director59

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.
 
Top