comparing two spreadsheets?

M

mika.

Hi,

Is there a way to automatically delete duplicates from two
spreadsheets? Basically I would like to take spreadsheets
A and B, and output any values that are in A but not B and
vice versa into spreadsheet C. Does excel have any
functions for doing so or do you know where I could find
an addin or macro?

Thanks kindly
mika
 
Top