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