In Workbook A I am pulling information from one data base. In Workbook B I
am pulling information from another data base. In Workbook A I want to
incorporate some of the data from Workbook B that meets a certain criteria.

Workbook B data:

Lease ID Tenant Status

HO106909 ABC Company Active
HO107904 XYZ Company Inactive

In workbook A I want to retrieve only those leases that meet the status of
"Active. " Any ideas on how to accomplish this task working from Workbook A
--as Workbook B is automatically updated weekly? I would like to run a macro
to look for the data from Workbook B.

Thanks for your help.

KK