How do I purge data in Excel 2003

M

M.E. Jetsam

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)
 
P

PY & Associates

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