Sedang Disiapkan

Excel Web Query Project

Hi this is for two mini-projects, both are similar in nature. Both require the filling of data into Excel spreadsheets, where the best way to do this would be the use Excel's Web Query feature to pull the data from a couple websites in an automated fashion by setting up the code in VBA. I've done this before and it works well, but don't have the time to do it myself in this case.

Please see the attached Excel file.

1. Tab: This American Life

Please fill in all the columns in this spreadsheet. Use the information I've already filled in as guidance for how I want it.

You'll need to pull the information from the site below:

[url removed, login to view]

2. Tab: DVDs

a. First, please clean up the Old Names, and put the New clean name into the "New Name" column. See my examples for how I would like it.

b. Then fill columns C - J by pulling the data from the website [url removed, login to view]

Please leave the VBA code you use in the finished product so I can re-use it in the future if I want to add in additional information.

I'll want to check the finished spreadsheets before I submit payment.

Thank you.

Kemahiran: Excel

Lihat lebih lanjut: excel web query, excel web query post, excel web query vba, excel query website aspx, web query aspx, secure web query excel, query project, vba excel web query, web query excel, sas excel, works need excel, best site web, pull data website excel, n query, life works, first american, fashion names, best web project, best fashion websites, best excel spreadsheets, excel 2008 web query, excel web queries secure, aspx excel query, project query log, web query record vba

Tentang Majikan:
( 94 ulasan ) Golden Valley, United States

ID Projek: #354975

Dianugerahkan kepada:

sumeet00

Hi, The file you have provided is a Winrar file and it doesnt have any xlsx file in it.Please check. As per your requirement, i m interetsed and would like to do it.Provide proper excel file pls. Thanks, Sumeet.

$30 USD dalam 2 hari
(1 Ulasan)
1.0

17 pekerja bebas membida secara purata $100 untuk pekerjaan ini

MAnkita

Hello,Please refer your PMB.Thank you.

$250 USD dalam 3 hari
(47 Ulasan)
5.7
gvyshnya

I am interested in doing your assignment.

$80 USD dalam 2 hari
(6 Ulasan)
4.1
yousefla

Hi, More info in the PM. Best Regards, Yousef

$250 USD dalam 5 hari
(4 Ulasan)
3.3
refractocd

This can certainly be done using Excel VBA. I am ready to start IMMEDIATELY. Please refer to PM.

$80 USD dalam 2 hari
(3 Ulasan)
2.5
crajeshbe

Excel VBA & web query Expert. Ready start right now. Regards C.Rajesh B.E

$30 USD dalam sehari
(0 Ulasan)
0.0
kiracle

Hi! Please see PMB. Thanks!

$30 USD dalam 2 hari
(0 Ulasan)
0.0
Heera102

Sir i am able to do this work. please consider me about this work. Thank you Have a good day.

$30 USD dalam 5 hari
(0 Ulasan)
0.0
YashpalSingh123

Hi, Expert Computer Engineer, Can Start Work on Immediately effect. Thanx

$200 USD dalam 5 hari
(0 Ulasan)
0.0
brunoramossilva

Payment Terms: 25% due upon award acceptance 25% due upon first milestone completion 25% due upon second milestone completion 25% due upon project completion We may negotiate this plan.

$250 USD dalam 15 hari
(0 Ulasan)
0.0
alihassan89

Hello Sir/Madam, I have a experience of a couple of years in DATA ENTRY field. I have recently finished a project working with a hospital's data, you may access their blog by using the following URL http://www.medi Lagi

$80 USD dalam 5 hari
(0 Ulasan)
0.0
shanthipavan

Hi, I am interested to work and I have the capability to do the work.

$50 USD dalam sehari
(0 Ulasan)
0.0
stupidity

i 'll help you sir ...

$100 USD dalam 7 hari
(0 Ulasan)
0.0
liyakath2305

We are Interested in this project.

$100 USD dalam sehari
(0 Ulasan)
0.0
kirakhaliq

i am new one but u will see the difference with quality work.just give me one chance please...

$40 USD dalam 2 hari
(0 Ulasan)
0.0
nijhu815

Greeting Sir,I am a good worker.I try to work for you very swiftly and thats why I need 5 days for this job.Please Sir consider me.I am waiting for your consideration.Have a good day.Thanks.

$48 USD dalam 6 hari
(0 Ulasan)
0.0
idealgroupltd

sir im interestadto this job please give me a chance sir. thank sir.

$50 USD dalam 10 hari
(0 Ulasan)
0.0