I need an application written to automatically take a number from one excel column (labeled "AIN" column), and enter it into a website "http://assessor.lacounty.gov/extranet/guides/supptaxcalc.aspx" in the search bar labeled "AIN". A property address will appear for each AIN, and I need the address scraped from the website and entered into the empty column "property address" next to the "AIN" column in the excel spreadsheet. There are over 100,000 rows of data, here is a link to the excel file:
[url removed, login to view]
I need this done only for the sheet labeled "type 2"
17 pekerja bebas membida secara purata $130 untuk pekerjaan ini
I can provide you Excel VBA that will scrape property addresses for ALL AINs - be it 100,000 or 100. Further, it will not use any 3rd party components. Please see PM for details and a DEMO.