Excel 2007 : Duplicates

How do I create a macro that will search for duplicates between column A of one workbook and column A of another workbook and place in a third workbook?

tiffanytt,

If you want to extract the duplicates between two workbooks (we'll call them wb1 and wb2) and then save the extracted duplicates into a third workbook, you can use the following macro:

Please Login or Register  to view this content.

To use a macro:

1. Make a copy of the workbook you'll be running the macro in (in this case, its wb1)
   • Always run code on a copy so that you don't lose the original just in case the code doesn't run smoothly
2. Press Alt+F11 to open the visual basic editor
3. Insert -> Module
4. Paste the code into the module
5. Close the visual basic editor
6. Alt+F8 to open the Macros dialogue box
7. Double-click on the macro you want to run (I named this one tgr)

Hope that helps,
~tigeravatar