Compile data from web source to excel
$30-250 USD
Bezahlt bei Lieferung
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
Projekt-ID: #809670
Über das Projekt
17 Freelancer bieten im Durchschnitt $77 für diesen 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