Duplicate Macro for Closed Workbooks
 

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.