Macro to retrieve web data based on contents of a cell

[amadden]

Hi all,

Longtime member, but first-time poster. Please forgive me if this is addressed elsewhere in the forum.

I have a data set that contains approximately 500,000 rows of data related to properties in my county. Each row of data corresponds to a distinct property, and has a unique identifier (Parcel ID). What I'd like to do is create a macro that pulls information from the county website associated with each Parcel ID. The county website allows you to search by Parcel ID (http://www2.county.allegheny.pa.us/R...te/Search.aspx), so it's a matter of taking the Parcel ID in cell A1, A2, A3, etc., populating the form, searching, and pulling results from the next page.

I've tried recording a macro but am running into some challenges. Does anybody have a recommendation for how I might be able to go about this?

Thanks,
Andy

[AB33]

pulls information from the county?
What sort of information?
Do you have Parcel ID for testing?
It is difficult to say if it is possible with out seeing the pages.

[amadden]

Thanks for the quick response; I'll try to explain it a little differently.

My county has a public database of property information that can be searched based on Parcel ID. The website is http://www2.county.allegheny.pa.us/R...te/Search.aspx.

I have a list of every Parcel ID in the county in "Column A" of my workbook. I'd like to create a macro to take the Parcel ID in Column A, search for it in the public database at the URL listed above, then return the "Owner Name" from the resulting page into "Column B". I'd like to repeat this process for each Parcel ID.

A sample Parcel ID for testing is: 0236A00100000A00

Does this help to clarify?

Thanks.

[AB33]

So, you just want to return

Owner Name : REDEVELOPMENT AUTH OF ALLEGHENY COUNTY

Right?
half- million rows will take long time to process

[AB33]

You seem to have disappeared with out answering my question.
Please put all numbers from A2 down as shown on the attached and run the code.
Please try it first on 100 rows.

[sanram]

I am not so good in data scrapping. But you can use this macro. But see the attachment to be confirmed.

Please Login or Register  to view this content.

[amadden]

AB33 - Your macro worked well on a test data set of ~250 rows. I am going to try to run on the full dataset overnight and see what the result is. I will keep you posted.

[amadden]

AB33 - while my Excel crashed a couple times, this did end up doing the job. I had to chunk it out and run several smaller jobs. Thanks a lot for your help!