data not imported in excel

[icssushil]

I have entered Roll Nos in B2, B3, B4 and B5 (1706571, 1706572, 1706573, 1706574) and I want their percentages to be entered in column C2, C3, C4 and C5 respectively for which i have written a vba code. But this code is only showing value for cell B2 and not for rest data, moreover percentage shown is not entered in C2. Please help.
I am using excel 2007

Code written by me is

Private Sub CommandButton1_Click()
Dim IE As Object
Set IE = CreateObject("InternetExplorer.Application")
IE.navigate "http://rajresults.nic.in/resbserx19.htm"
IE.Visible = True
While IE.busy
DoEvents 'wait until IE is done loading page.
Wend


IE.document.all("roll_no").Value = ThisWorkbook.Sheets("Sheet1").Range("B2")
Set doc = IE.document
Do While doc.ReadyState <> "complete": DoEvents: Loop
doc.GetElementsByName("B1")(0).Click


End Sub

Please help to resolve the issue

 

[kweaver]

Are you looking for the percent EACH one is of the TOTAL of all four? In this example, they'd all be 25%.

 

[icssushil]

I need that roll nos given in excel should be uploaded into website and the result shown thereafter i.e. percentage scored by that roll no. should be extracted to excel in front of that roll. no. and it should be for all the roll numbers entered in excel.
Thanks

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1100426-vba-code-automation.html#post5291104

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).