How do I purge data in Excel 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data comparison for duplication 1
excel duplicated a sheet. how do i delete one 2
how do i resize column letters in excel 2007 1
my vlookup path changes when I open the file 1
How do pull data from more than one excel wookbook to one? 1
consolidate and compare workbooks in excel 1
Comparing 2 worksheets in Excel 2007 1
How do I merge/combine different workbooks with different sheets 2

Back
Top