I am working on a project that has proven to be extremely time consuming and I wanted to know if there were any ideas for a web query that could automate my efforts of searching a website's database and going through entries and placing each entry in a row in excel or access.
for example here is the database I'm searching - [url removed, login to view]
from that list I have to manually select each of the neighborhoods (one after another). Once the search returns there are thousands of records of which I have to click into each and extract;
Address | Neighborhood | Use Code | Land Area | Owner Name | Mailing Address | Sale Price | Recordation Date | URL
then I go back to the search results and do the same thing over and over for the next listings. This has proven to be extremely time consuming and I was just wondering if there were a way to automate this. Also, it would need to be flexible enough that my spreadsheet updates with the results once news ones are added.
If you are able to do this I would offer up to 10 additional projects, same task but different websites that need to be able to be imported into the same or another worbook, we could also negotiate a rate increase.