power query or macro - extract data from scholaro (website)

With power query or macro you can extract data from this site:
https://www.scholaro.com/ed/Countries

I would like to import in a file for each state the following data to be inserted on each sheet with the name of the data type (education system etc.) the following data:
1) the table on the education system and the description below;
2) Credentials;
3) Universities (in this case I would need a list of all the universities in the state with all the indications for each university ranging from the website, address and ranking) to add to the columns "local name" and city, then: web rank (in the three types), General Information, Links, Location, Students and Staff, Tuition, Admissions.
4) resouces (indicating in a table the name and other data as a website, etc.)

Maybe it's a bit complicated

I posted a difficult case?

As that needs some time and as it seems you did nothing so you can see with the commercial services of this forum …

There are many expert users who could give a solution to this question.
This is a forum with many more users than others and sometimes it can happen that a post is not read.

said:

Being ready is a lot, knowing how to wait is better, but exploiting the moment is everything.
(Arthur Schnitzler)

The real work is knowing how to wait.
(Jean Rostand)

The expectation of pleasure is itself a pleasure.
(Gotthold Ephraim Lessing)

The wait is the future that comes with empty hands.
(Michelangelo)



This is for you marc:

Walt Whitman "O Captain! My Captain"

O Captain! My Captain! our fearful trip is done;
The ship has weather'd every rack, the prize we sought is won;
The port is near, the bells I hear, the people from the exulting,
While following the steady keel, the vessel grim and daring

But O heart! heart! heart!
O the bleeding drops of red,
Where on the deck my Captain lies,
Fallen cold and dead.

O Captain! My Captain! laughed up and hear the bells;
Rise up for the flag is flung for you the bugle trills;
For you bouquets and ribbon'd wreaths-for the shores a-crowding;
For you they call, the swaying mass, their eager faces turning

Here Captain! dear father!
This arm beneath your head;
It is some dream that on the deck,
You've fallen cold and dead.

My Captain does not answer, his lips are pale and still;
My father does not feel my arm, he has no pulse nor will;
The ship is safe and sound, its voyage closed and done;
From the fearful trip the victor ship comes in with the object won

Exult, O shores, and ring, O bells!
But I with mournful tread,
Walk the deck my Captain lies,
Fallen cold and dead.

https://www.youtube.com/watch?v=E5t3ZzZv8_U

« Di grand' eloquenza, poca coscienza. »

« Parla bene, ma parla poco, se vuoi esser stimato. »

« Veder la pagliuzza nell'occhio altrui e non veder la trave che sta nel proprio. »

« Chi ben comincia è alla metà dell'opera. »

« Never argue with an idiot, he'll bring you down to his level - then beat you with experience. »


So, as with the samples you can see on several forums and the web tutorials as well,
as here it's a VBA forum so at least show us what you have done so far …

You know very well that I can not do it.
What I could do and just ask in more forums or find a macro that does something approaching using the search in the forums or on google.
If you want to continue to hinder me or denigrate, go ahead. I have purposes of public utility that you will not find easily in others and that your sayings do not suit, especially the last one that is close to your heart.
You can not do or write anything you want but you will not stop me ...

for you:

To all the madmen. Solitaire. The rebels. Those that do not fit. Those who do not exist. Those that always seem out of place. Those who see things differently. Those that do not fit the rules. And they have no respect for the status quo. You can agree with them or disagree. You can glorify or defame them. The only thing you can not do is ignore them. Because things change. They push the human race forward. And while someone considers them insane, we consider them genes. Because people who are crazy enough to think they can change the world are those who really change it.
Steve Jobs

« Man can go forward just reading, learning and trying … »

So just wait and hope someone has time to waste or after a while move to the Commercial Services of this forum …

you are absolutely right in the first sentence.
If I had to start now I would learn in a few years. I have little time to try and do what I would like to do. Learning for me is not a problem and time is missing ..

I just have to wait

I'd tend to agree with Marc and steer you towards the commerical services forum. There is likely a couple of hours work here for someone, there isn't a quick fix. Additionally there aren't a great number of people here who have a lot of experience in scraping websites so I suspect that you aren't going to have much luck getting a response.

You could try making a little more effort in demonstrating exactly what layout you want. Upload a sample workbook that demonstrates exactly how you want the data laying out, put in the data you want manually for at least 2 countries. This would be a massive help and time saver for anyone looking to help