How do I purge data in Excel 2003
 

I have 6 different workbooks to mail merge with 6 different letters. Same
names may be in several workbooks. How do I compare all workbooks to delete
duplicates, leaving same names in only one workbook? (account number in
common)

Read all 6 workbooks into one workbook,
sort by the selection criteria,
delete rows with duplicate (from bottom up)

"M.E. Jetsam" wrote in message
...
I have 6 different workbooks to mail merge with 6 different letters. Same
names may be in several workbooks. How do I compare all workbooks to
delete
duplicates, leaving same names in only one workbook? (account number in
common)