Two things I can think of:

1) Assuming the two spreadsheets have the same data...just different
people (and same people; thus duplicates) - Copy all of the data into
one spreadsheet and then short by name. Then create an if() function
in the last column to determine if the current record is identical to
the previous record...if it is, tag it as a "1"...if not..."0". Paste
this new column as values when you are done and then sort by this
column...all of the duplicates will get sorted to the bottom and can
then be deleted. You could also do this with a pivot table; if you
know how to use a pivot table.

2) Assuming the table has different info for the same people (one table
has address...other table has birtdays, etc). You a series of vlookups
to merge data between spreadsheets.


--
Lotus123
------------------------------------------------------------------------
Lotus123's Profile: http://www.excelforum.com/member.php...o&userid=28611
View this thread: http://www.excelforum.com/showthread...hreadid=482643