Excel Based Process Automation

₹400-750 INR / hour

Kapalı

İlan edilme:

10 yıldan fazla önce

₹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.

Proje No: 5409476

Proje hakkında

7 teklif

Uzaktan proje

Son aktiviteden bu yana geçen zaman 10 yıl önce

Biraz para mı kazanmak istiyorsunuz?

E-posta adresi

Freelancer'da teklif vermenin faydaları

Bütçenizi ve zaman çerçevenizi belirleyin

Çalışmanız için ödeme alın

Teklifinizin ana hatlarını belirleyin

Kaydolmak ve işlere teklif vermek ücretsizdir

7 freelancer bu proje için ortalama ₹657 INR/ saat teklif veriyor

@bharat1010

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 5 gün içinde

5,0

(6 değerlendirme)

3,7

@spaul1107

A proposal has not yet been provided

₹638 INR 5 gün içinde

5,0

(2 değerlendirme)

1,7

@RAJCDAC

A proposal has not yet been provided

₹638 INR 5 gün içinde

5,0

(2 değerlendirme)

0,9

@mrg678

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 5 gün içinde

0,0

(0 değerlendirme)

0,0

@alexsandres

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 5 gün içinde

0,0

(0 değerlendirme)

0,0

@agronmuhaxhiri

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 5 gün içinde

0,0

(0 değerlendirme)

0,0

@freelanceUSap

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 5 gün içinde