Extract exam result from website

[Suvadip Paul]

I have a excel file containing the Roll numbers of candidates (attached file). 

To find their result from the website,  I need to follow the below link

http://www.tripurauniv.in/index.php/result  >  TDP/TDPH (B.A, B.Sc, B.Com) 2nd Semester Examination -2015>Search Result

Then I put the roll no one by one and extract result. Copy the result and paste it again in the excel file against the corresponding candidate. 

Please guide me how to write a program for me in excel so that whole process can be made automatic. The program will input the roll nos one by one in the input field and  extract result and paste the corresponding result again in the excel file.

Finally I should have a excel file where all the four columns (of the attached file) are filled. I even dont know whether it is possible. Presently I use excel 2007