Is it possible to attach in Bytes the HTML data so we can see the structure?
If the data is confidential, please replace it with recemblant but harmless data.
Can you also give an example how you want the data in the Excel sheet?
In this call "Looping Marco thur url" from Sandy Armstrong we capture data from URLs of hospitals.
You can import the tables and split them in sheets.
If you want more help, please send us more details of the URLs and the sheet you want to use.