I have numeric values and a string condition in different workbooks and I need to run some comparisons to extract the information into a new workbook.
Keep in mind each row has additional info like name, address, etc.

WrkBk_2Sht_1Col_B has account numbers

WrkBk_1Sht_1Col_A has account numbers
WrkBk_1Sht_1Col_B is empty or contains "DEAD"

All of the account numbers in WrkBk_2Sht_1Col_B should be a subset of the larger list in WrkBk_1Sht_1Col_A, however anomalies do occur and I need to compare the numbers in WrkBk_2Sht_1Col_B to the ones in WrkBk_1Sht_1Col_A and kick out a copy of the entire row (from WrkBk_2) for which the WrkBk_2Sht_1Col_B number does not match one in WrkBk_1Sht_1Col_A.

In addition, even if an account number in WrkBk_2Sht_1Col_B matches one in WrkBk_1Sht_1Col_A if it is designated as "DEAD" in WrkBk_1Sht_1Col_B it also needs to kick out a copy of that row (from WrkBk_2).


Drawbacks:
The workbooks are not static. At any point in time I will be doing this for two different workbooks so the formula or macro cannot reside with one of the workbooks with account info. It would be possible to keep a single workbook for the results(copies of the accounts violating the parameters) of all comparisons to be placed in and that may be the best place to keep a macro/formula.
I can create nifty physics lab workbooks with lots of custom formulas, bells, and whistle, but this accounting issue has me stumped.