Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Data Matching Criteria in a separate spreadsheet
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search worksheets in same book to return value matching criteria? | Excel Worksheet Functions | |||
I want to use a link to return all data matching a criteria | Excel Worksheet Functions | |||
Sorting and Matching criteria across rows to return a result in the last cell | Excel Worksheet Functions | |||
Return across Row Numeric Values Matching EXACT Month & Year for Criteria | Excel Worksheet Functions | |||
Return Numeric Values Matching EXACT Date for Criteria | Excel Worksheet Functions |