Well, you can write a VBA procedure that would compare the rows and/or
cells and delete and/or flag (color?) those rows that were dups so you
could deal with them.
Manually, just sort the table once merged and delete those rows you
don't want.
Dian D. Chapman, Technical Consultant
Microsoft MVP, MOS Certified
Editor/TechTrax Ezine
This article by ibby has some code (and a link to a "wildcard replacements" article that shows how to remove duplicate *paragraphs* if you can turn the table into text without problems): http://www.word.mvps.org/faqs/macrosvba/DeleteDupRows.htm
I guess you can sort the table? Else, you'd need to insert an extra column, number that, sort, delete duplicates, sort using the numbered column, and then delete that column again.
Regards,
Klaus
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.