10-18-2009, 05:26 PM
I'm having a difficult time figuring out how to do the below task. Here is the scenario.
I have an database in Excel 'sheet1' consisting of properties and property contacts. Each row contains a property and related contacts.
1. I need to extract their "lastname" "firstname" "city" "state" & maybe "zipcode" from Excel, find their contact information via Anywho.com,
2. then paste the one or many results (i.e. name, address, and phone number) along with the corresponding Property "PIN", in a xls sheet2 same workbook.
2.5 there may be one or more than one related contact for any one property, all property related contacts are on the same row.
3.Needs to run until it reaches the last property PIN.
Example (xls sheet1)
PIN lastname firstname city state zip lastname2 firstname2 city2
1212123123 Doe John Chicago IL 60601 Smith James Plainfield
I do appreciate any help, thank you.
__________________
Respectfully,
Snwskier2
I have an database in Excel 'sheet1' consisting of properties and property contacts. Each row contains a property and related contacts.
1. I need to extract their "lastname" "firstname" "city" "state" & maybe "zipcode" from Excel, find their contact information via Anywho.com,
2. then paste the one or many results (i.e. name, address, and phone number) along with the corresponding Property "PIN", in a xls sheet2 same workbook.
2.5 there may be one or more than one related contact for any one property, all property related contacts are on the same row.
3.Needs to run until it reaches the last property PIN.
Example (xls sheet1)
PIN lastname firstname city state zip lastname2 firstname2 city2
1212123123 Doe John Chicago IL 60601 Smith James Plainfield
I do appreciate any help, thank you.
__________________
Respectfully,
Snwskier2