HELP REQUIRED Macro for Multiple Hyperlink , copy and paste into excel

Hi everyone,

I am looking for a solution to copy and paste some specific value from web browser into excel file , basically there are 3 column each with different value , basically the formula should open the page link on ( L column) ,copy specific value inside the webpage and paste in the (J column) if the copied value is < 10 mark Red on ( K column ) if >10 Green


All link are set in this way : ( J column ) is the available product from the website
(K column ) become red or green if available product are below 10(red color ) above 10 ( green color)
(L column ) are the webpage links

J K L

1 (red) Link
9 (green) Link
22 (green) Link
3 (red) Link
5 (red) Link



Anyone can please advice or guide trought the process , sorry I don't know much about excel formulas hope someone can HELP THX