Data from website to excel automatically

[MPiii]

Hello. I need help with Excel / VBA.

My problem is as follows:

I want some data from this page:

Soccer Team Profiles | Football Teams

Check here for soccer team profiles playing all major leagues in the world: league statistics, historic results, players and news.

www.soccerstats247.com

Here I have to select "Domestic Club" and on the right one, I want all of the leagues with all of the teams and their data in Excel to calculate the probablity just like that:

Gyazo

gyazo.com

I can calculate the probablity easily, but I dont know how to get the data from each team AUTOMATICALLY. Thanks in advance.

 

[mrshl9898]

You can go Data > From Web > and add the URL to return a table.

This is Table 0 from URL Apolonia Fier – soccer team profile, Apolonia Fier Fixtures

 

[MPiii]

Thanks for your answer @mrshl9898,

but then I have to do that for every single team, I want to automatically import all teams into excel.

Is there a way?

 

[Marc L]

(removed as this is a wild cross posting thread …)

 

[mrshl9898]

You'll need all URLs whether you automate ie or import the tables.

May just need to bite the bullet here and invest the set up time, or find a different data source

 

[mrshl9898]

If you have all the team names you could probably guess the URLs though and import the tables. Would save some time

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: How do I get soccer data from website automatically to excel - OzGrid Free Excel/VBA Help Forum
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.