This is for 2 separate programs.
I need to have a program created, ideally a macro but open to suggestions. There are 2 data websites I want to scrap data from. This will also lead to similar projects for other counties to do a very similar thing. I have an excel file with some 45k rows with a tax id# in column A (example included). I want the program to go out to this website [login to view URL]
The program then takes each tax ID # and inputs it into the "tax map number" and then clicks go. I want it to then gather the last 2 columns of data "Status" & "Entered" and capture this data and put it back into the excel file with the associated tax id#. I then want the program to move to the next row and continue this through the entire 45k records. If it does a search and there are no results it says "Your search for Taxmap Number "number would be here" produced no results..." in which case I want it to put into excel "NO VIOLATIONS" and more to the next.
Program 2
The next data scrapping is for this website [login to view URL] I want it to start with a fresh excel file and look for the term "TRUSTEE'S SALE" or "Trustee Sale" and if it does say that then click the "more detail" link to get the information that will go into excel. Here is an example of the data that is in the more details page when it opens.
[login to view URL]
I have the excel file showing the data it must gather. FOR BOTH PROGRAMS IT IS IMPERATIVE THAT THIS IS AUTOMATED SO IT CAN BE DONE DAILY. THIS IS NOT MANUAL DATA ENTRY THIS IS A PROGRAM THAT DOES ALL OF THIS FOR ME WHENEVER I WANT! I envision it as a macro but if you have a better programming language that will do the work then I am open to suggestions. Please leave a message if anything is unclear before bidding.
If you do a good job I will have more of this type of work that is very similar in nature.
********************************************.. 11 YEARS of EXPERIENCE .. ******************************************************
Hi, I can meet your deadline