transfering data from a website to excel

[yamenhakmi]

I have a problem I have a sheet of 800 people everyone has a serial number but the results of exams of these people are in a site that shows you the results of every individual once you put in the serial number.so i need a program that read the name in excel take his serial number then put it in the site and take the results to print it in excel next to the name of the person automatically.is there a way to do that

 

[alansidman]

Build a parameter query in Power Query to retrieve the specified data. Without more specific information, ie. Web site and required output, this is the best I can offer.