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 lagi: 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, www rottentomatoes com, www excel, works need excel, the best site web, rottentomatoes com, pull data from website to excel vba, pull data from website into excel, n query, mini web 2.0, life works, how excel works, first american, fashion names, excel to web, excel &

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

ID Projek: #354975

Dianugerahkan kepada:


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

$30 USD dalam 2 hari
(1 Ulasan)

17 pekerja bebas membida secara purata $100 untuk pekerjaan ini


Hello,Please refer your [url removed, login to view] you.

$250 USD dalam 3 hari
(47 Ulasan)

I am interested in doing your assignment.

$80 USD dalam 2 hari
(6 Ulasan)

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

$250 USD dalam 5 hari
(4 Ulasan)

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)

Excel VBA & web query Expert. Ready start right now. Regards [url removed, login to view] B.E

$30 USD dalam sehari
(0 Ulasan)

Hi! Please see PMB. Thanks!

$30 USD dalam 2 hari
(0 Ulasan)

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)

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

$200 USD dalam 5 hari
(0 Ulasan)

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)

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 [url removed, login to view] Lagi

$80 USD dalam 5 hari
(0 Ulasan)

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

$50 USD dalam sehari
(0 Ulasan)

i 'll help you sir ...

$100 USD dalam 7 hari
(0 Ulasan)

We are Interested in this project.

$100 USD dalam sehari
(0 Ulasan)

i am new one but u will see the difference with quality [url removed, login to view] give me one chance please...

$40 USD dalam 2 hari
(0 Ulasan)

Greeting Sir,I am a good worker.I try to work for you very swiftly and thats why I need 5 days for this [url removed, login to view] Sir consider me.I am waiting for your [url removed, login to view] a good day.Thanks.

$48 USD dalam 6 hari
(0 Ulasan)

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

$50 USD dalam 10 hari
(0 Ulasan)