I need a VBA macro that pulls the "z" estimate of a property from Zillow .com.
I have a spreadsheet with thousands of rows that contains home addresses in the U.S.
The macro should search by column header - not by column "A", "B", etc.
Column Headers would be
We would then want the value exported into a column with the header "Home Value"
We would also like to find a way to do a reverse phone lookup searching by a fuzzy match to name plus the addresses. The phone number would be exported to a column called "Phone Number".