Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMIF linking to closed workbooks. | Excel Discussion (Misc queries) | |||
Copying From Closed Workbooks | Excel Worksheet Functions | |||
Information from Closed workbooks | Excel Discussion (Misc queries) | |||
Updating links to closed workbooks | Excel Discussion (Misc queries) | |||
Referencing cells in closed workbooks | Excel Discussion (Misc queries) |