Compile data from web source to excel
$30-250 USD
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
Project ID: #809670
About the project
17 freelancers are bidding on average $77 for this job
hi I am Ready to do ths job work ya gone through the additional features i am ready to do this project work
Hello Sir, I have given sample tool as per your requirements. Please check PMB.. Regards, Somnath