I am doing a project where I need to input into excel a listing of all tradespeople and their license information.
I am looking for an automated macro that I can use to grab column data from a web page.
I would like to manually select the type of license I am looking for and search the state database based on zip code. I want an automated macro that will take zip codes that I have on a spreadsheet and run the search. From the results page I need the macro to capture all data in the respective columns and put it into excel. Once the macro is finished capturing all the data that is returned, it needs to go back to the previous page and replace the zip code with the next one on the list and conduct the next search and data capture.
The website and input fields are located at [login to view URL]
As an example, once you are on the page, select ELECTRICIANS from the drop down menu of license type and input 02494 into the zip code field and press search to see the results.
This automated macro needs to be simple to use and function as I do not have experience using them.
Hi!
I have the algorithm set to extract your data:
It's a matter of coding the standalone application now.
Let me know if you are interested so we can discuss the project over at Skype.
Thanks for reading my proposal.
Vicente
NB: Please check my Portfolio for latest project addition - Configure a scraper to extract data from license website. If interested, I can deliver immediately, but we have to discuss the project over Skype.
Thanks
I have more than 6 years of experience in Excel and SQL. Besides that I have good understanding of VBA and other upcoming technologies that can be easily used and applied.
Have a valid SQL (local) license with Excel 2010. Having worked as an Analyst (not a programmer) i understand day to day problems faced by users and my job involves creating simple solutions for various problems faced by operation groups.
Excel and SQL are my forte and I take pride in creating effective solutions. I would be happy to provide a sample solution. I can also create, simple to use and understand VBA codes if required.
I have previously created automation to create online ads on websites like Quikr. I can send across the sample if needed.