Compare Cells in Two Workbooks
Does workbook A have multiple sheets? If it does, what sheet do you want to
work with? What column in workbook A?
What sheets in workbook B? All of them? Do you want to check just cell for
cell or do you want to check if the value is in any cell in the specific
column in the pertinent sheets in workbook B? What version of Excel are you
using? HTH Otto
"msnyc07" wrote in message
...
Is it possible to have a script that does the following;
Compares all the Cells in a specific column in WorkBookA to all Cells in a
specific column in multiple sheets in WorkbookB
If a match is found in B, remove the entire Row in WorkbookA
Thanks in advance for any help
Michael
|