Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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) |
#2
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Replace data by VALUE or COMMENTS not availabel in Excel 2003 ??? | Excel Discussion (Misc queries) | |||
How do you move names and data between large Excel 2003 workbooks? | Excel Worksheet Functions | |||
For Excel 2003: Is there a way to copy and paste a row of data to. | Excel Discussion (Misc queries) | |||
how do I install data analysis add ins to excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 This Workbook contains queries to external data | Excel Discussion (Misc queries) |