Find Jobs
Hire Freelancers

Excel Based Process Automation

₹400-750 INR / hour

Closed
Posted over 10 years ago

₹400-750 INR / hour

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.
Project ID: 5409476

About the project

7 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
7 freelancers are bidding on average ₹657 INR/hour for this job
User Avatar
I am an expert in excel macro/VBA and would be glad to work on your project. I can send sample for your perusal.
₹644 INR in 5 days
5.0 (6 reviews)
3.7
3.7
User Avatar
A proposal has not yet been provided
₹638 INR in 5 days
5.0 (2 reviews)
1.7
1.7
User Avatar
A proposal has not yet been provided
₹638 INR in 5 days
5.0 (2 reviews)
0.9
0.9
User Avatar
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
₹833 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, Generally, I have generate macro code for your job. Just let me know if you're interested and pick me as the winner. Alex
₹611 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I already made a tool for you which it can search the data and scrape it to the excel file. I hope that I will hear very soon from you. Best regards
₹638 INR in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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.
₹600 INR in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
India
0.0
0
Member since Feb 8, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.