I need the end product to be as user friendly as possible.
I have an excel spreadsheet with raw data in it.
I need to extract data from the web using criteria from the spreadsheet.
Raw data file is uploaded.
I want to to press a button or run a macro or whatever is easiest for you, when I execute the programming, this is what I need to happen:
1) Spreadsheet need to get a "zestimate" value from [url removed, login to view] (Via API from zillow)
Spreadsheet will need to provide, street address, city, state and zip code to retrieve zestimate
2) A new column will need to be created in the spreadsheet labeled Zestimate, and retrieved data from zillow api inserted into this new column. I would prefer the zestimate column to be placed right beside the list price column.
3) I do not want any errors to occur. Sometimes the zestimate value is unavailable. I will be processing approx 500 properties at a time and can not afford to have any timeout errors, if it can not find what its looking for, i need it to search the property on the next line.
4) I would like this done ASAP, please let me know how long this will take you.