Web Scraping

I am trying to pull the 2014 assessed values from my county assessors website and put them into a spreadsheet. I have the parcel numbers of the properties that I need and I would like to enter the assessed values next to the parcel numbers. The code below is what I have so far. I'm able to get the information from the table on the website to import into the spreadsheet but getting the right cell to copy into the cell next to the right parcel number and loop correctly has stumped me. If there is a better way of doing this where I don't need to import the entire table and then delete it every time let me know. I'm not too familiar with web programming. I have also attached a sample of parcel numbers. Thanks!

Please Login or Register  to view this content.

That works well. One problem though. Parcel numbers in this county are 10 digits long. Often the parcel number starts with a 0. (See example file) When the web query enters the number it is leaving off the 0. The web site does not recognize the parcel numbers so it's skipping the parcel and not returning a value. I know this is a separate issue... but related. Any ideas?