I need a VBA macro that pulls the zestimate and rent zestimate of a property from Zillowcom.
I have a spreadsheet (with multiple rows) that contains home addresses in the U.S.:
A - Street Address
B - City
C - State
D - Zip code
E - Zestimate (this is what I need you to provide)
F - Rent Zestimate (this I need as well)
I need someone to program a macro or otherwise to populate the Zillow Zestimate home value and Zillow Rent Zestimate rent value. I'm fairly computer literate, but learning Excel VBA for this project will require too much time on my behalf.