Transferring data from many different websites to Excel

I have a (long) list of websites on sheet sites and I want to transfer the relevant data from those websites to sheet Results.
How can I best do that?

Note: Relevant data is the data in the tables, but not the data in the headers and footers.

See in attachment example with 4 websites.

96 hours later:

51 views,
7 downloads,
0 replies.

Does that mean what I'm asking isn't possible or was everyone looking for Easter eggs?
If it's not possible, could someone post why that is?

Thanks for the help.

It's the Easter weekend - you porobably shouldn't expect people to be at your disposal over a holiday.

Pretty sure it's doable with PowerQuery, but you are at the mercy of the PQ experts.

There are MANY tutorials for scraping data from multiple web pages online. Here's a Google search:

https://www.google.com/search?client...in+power+query

which includes:

https://www.youtube.com/watch?v=VkDpwSGWPmk
https://www.youtube.com/watch?v=PIu9U-2AAu8
https://www.youtube.com/watch?v=STjBoS1rQuQ
https://www.youtube.com/watch?v=QHX_bb9OGe4

Ali, Thank you for the tutorials.

I had also tried a few things, but couldn't get started.
Maybe I'm fiddling or doing something wrong or overlooking something or maybe the website is not suitable?

I am happy to wait for help from experts in this field.

Yes sure I'm.

I think I prefer VBA over power query.
Although I never post VBA algorithms myself, I do know something about VBA.

I don't know anything about Power Query.

Moreover, VBA offers more possibilities

Ok! Here you go. Open VBA, insert a new empty module and paste this code there.
Before you run this, clear your results sheet first.

You can start the code by running the "jec" macro.

Please Login or Register  to view this content.

Thank you Jec.
Could you tell me exactly which buttons I should click?
I don't see how to add a new module after clicking the developers tag.

EDIT: I have now figured out how to do it. See next post.

I have now managed to get the module working and it works perfectly.
Thank you very much for that.

I also modified the module, in case multiple columns are needed.
Would you like to adjust the module so that the link itself is also placed in the output (prior to the associated data in column A)?

By the way: Saving this macro enabled file on my laptop takes about 10 seconds. What could that be?

Hi Jec, I want the url in every row, I think about it now. That's the easiest starting point for me.

Hans said it took 10 seconds to save, not 10 minutes.

@Jac,

This works absolutely perfectly.
This allows me to move forward.
Also, the problems with saving the file no longer occur.

Thank you very much.

After JEC's macro has been working smoothly for a while, it now suddenly produces a compile error, which I can't solve.

I didn't modify the module.

What is the cause of this error and how do I fix it.

What if yiu delete all that code and only use the script in post 13?

I haven't opened your file yet but I think you use a combination of the two suggestions

Edit (openend your file): Yes, you have a combination. So, clear the whole module. Also macro "jec" and the global variables.
Then use the code of post 13 only.

Hi JEC,

Yes, when I ditch the JEC procedure, everything works fine again. It's strange that when I called JEC earlier it worked fine, but later that was no longer the case.
I can move forward again.

Thanks again.
Unfortunately, I cannot yet grant reputation again, because I have not yet awarded reputation to anyone else,