Compile data from web source to excel

Awarded Posted Sep 29, 2010 Paid on delivery
Awarded Paid on delivery

I need a tool created for excel in order to download tables from a stream of webpages from the same website that are all configurated the same way and are already in table format.

Basically means compiling information gathered at the following address:

[login to view URL]

Each of the links presented opens a webpage with a table content and I want the excel to retrieve it. Final presentation should be in a list and the collumns should be as follows:

Name of the fund | Bond | Size | Price | Acc. Interest | Total

Text | Text | Number | Number | Number | Number

From all the content in the table I only want the macro to retreive the data corresponding (under) to chapters:

111

112

113

121

131

132

133

141

151

153

173

223

231

Also, the macro should be able to convert the raw data into valid information (transform text into numbers, validate the "." to work as a comma/point and automatically clean blank cells/lines (any line that has a blank cell is to be eliminated as I won't need that info, namely the chapter's info). After compiling, results should be presented sorted alphabetically based on the cell "Designação".

Attached is an example of the final product I want with this project, based on two of the links/funds.

Plz check attachment

Excel

Project ID: #809670

About the project

17 proposals Remote project Active Oct 2, 2010

17 freelancers are bidding on average $77 for this job

damitha78

pleas see pm

$95 USD in 2 days
(0 Reviews)
0.0
pinky2406

hi I am Ready to do ths job work ya gone through the additional features i am ready to do this project work

$50 USD in 2 days
(0 Reviews)
0.0
kakaconsultancy

Please refer to PM.

$30 USD in 2 days
(0 Reviews)
0.0
LeeGia

Hello, I have experience.

$50 USD in 7 days
(0 Reviews)
0.0
amir708

hello, My six years experience in excel business field. i worked previous three years successfully. And i am a professional teacher of MS Office(excel, word, power point, access) And i have read your requirement , an More

$60 USD in 2 days
(0 Reviews)
0.0
shabbier

Hi, Gauranteed and honest work offered. Ready to go! Regards, Micheal.

$40 USD in 0 days
(0 Reviews)
0.0
ajira

hi... I can do it and I like to do work hard. thanks.

$85 USD in 15 days
(0 Reviews)
0.0
angelmake

I am full time freelancer and I work at home all the time currently. I will always give customer the best image on my business services. I valued every customer in my business which mean 'what I done is what you ask fo More

$60 USD in 3 days
(0 Reviews)
0.0
SomnathTingare

Hello Sir, I have given sample tool as per your requirements. Please check PMB.. Regards, Somnath

$200 USD in 1 day
(0 Reviews)
0.0
aravinda305

Dear Sir, Please check my PMB

$75 USD in 5 days
(0 Reviews)
0.0
janech

Hi there, I shall be happy to work on this. To place a bid I will need more details like what kind of data is to be entered? quantitative or descriptive and how much is the quantity? Is it a daily project? if so, by w More

$100 USD in 2 days
(0 Reviews)
0.0
deshaliperera

Pls give this project to me.

$30 USD in 3 days
(0 Reviews)
0.0
blonda

i am interested in your job

$250 USD in 1 day
(0 Reviews)
0.0
khushi44

Please see p.m.

$80 USD in 4 days
(0 Reviews)
0.0
sumit4sure

i have a lots of experience in excel.

$32 USD in 3 days
(0 Reviews)
0.0