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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Data Matching Criteria in a separate spreadsheet
Start recording a macro in workbook1
Go to workbook2 Filter on status Copy visible cells Paste in workbook1 Adjust the macro to your needs... "KalliKay" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Data Matching Criteria in a separate spreadsheet
Hi,
One simple method: 1. In workbook B turn on Data, Filter, AutoFiler 2. Open the filter for the Status column and choose Active. 3. Highlight the visible cells in the data area and copy 4. Switch to workbook A and choose Paste 1. These steps could be recorded into a macro. -- Thanks, Shane Devenshire "KalliKay" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Data Matching Criteria in a separate spreadsheet
I was trying to make it harder than it was. Thanks.
"Sheeloo" wrote: Start recording a macro in workbook1 Go to workbook2 Filter on status Copy visible cells Paste in workbook1 Adjust the macro to your needs... "KalliKay" wrote: 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 |
Reply |
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 |