Macro's need to be built for each specific task so you will not get code posted that suits your exact needs

For starts

Record a macro whislt you get data from the url

The recorded macro can then be added to a Workbook Open macro