macro to copy price from internet explorer and paste in excel

[Abby83]

Hello Everyone,

I need your support in creating a macro to copy ID's from excel and getting the value from IE and adding it in front of the ID

Used website "https://cportal.emicool.com/quickpay.aspx"

Sample ID's
EC101581
EC106396
EC104031

 

[vletm]

Abby83​

Are You asking ... paste in excel ... and later ... to copy ID's from excel ...
... without sample Excel-file as well as without expected results?

 

[Abby83]

Abby83​

Are You asking ... paste in excel ... and later ... to copy ID's from excel ...
... without sample Excel-file as well as without expected results?

i attached the file i'm working on, what i'm trying to do is, i want to search on the website with the ID's in the sheet and copy the value/amount from the website to the excel but i keep getting an error