Duplicate Macro for Closed Workbooks

N

NPell

Hello,

Does anyone know of a macro that i could edit/tweak that does the
following...
1) Looks down column A of Workbook1,Sheet1.
2) References this to Column B of Workbook2, Sheet1
3) Highlights the duplicates by placing a 1 in column B of Workbook1,
Sheet1

If this is do-able, is it then possible to do...
1) Looks down column A of Workbook1,Sheet1.
2) References this to Column B of Workbook2, Sheet1
AND
References this to Column B of Workbook3, Sheet1
AND
References this to Column B of Workbook4, Sheet1

Maybe even a pop-up box to choose which files to look in, or just do
one file at a time with this option?
3) Highlights the duplicates by placing a 1 in column B of Workbook1,
Sheet1


Thanks for any help at all in advance.
 

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

Need Help with a VBA subroutine 0
Return matching value 8
To copy Data from a row in one wrokbook and insert in a sheet of another workbook 0
Drop down lists from multiple source lists 3
Setting column width in a table with a macro is not working 0
HELP: IF Statement between Dates for Reverse Index failing 0
Lookup function to return highest value 4
Adding sequence numbers to paragraphs 0

Top