Extract from Multi links

[sampredh]

Hi all,

Looking For a macro that would Extract Data from specified links in Excel worksheet, I have hyperlinks in "A" column I would like data to be extracted in corresponding "B" Column, Below is The List:

A	B
http://www.ironplanet.com.au/for-sale/Tools-MAGNUM-4000-Portable-Hot-Pressure-Washer-w%2FEASY-KLEEN-Triplex-Wa%E2%80%A6-Oklahoma/1084615?h=5002%2Cmsg%7C21831X%2Csm%7C0%2Cprows%7C100%2Csort%7Cln+asc%2Cmsg_tab%7C23431X%7C21812X%2C%2CisAuc%7Cyes%2Cmf%7C1&rr=0.5&hitprm=msg_tab%3D23431X%7C21812X&pnLink=yes
http://www.ironplanet.com.au/for-sale/Utility-Vehicles-HONDA-Foreman-500-4-WD-ATV-p%2Fb-HONDA-500CC-Gas-Eng%2C-25x10.00-12-%E2%80%A6-Kansas/1084616?h=5002%2Cmsg%7C21831X%2Csm%7C0%2Cprows%7C100%2Csort%7Cln+asc%2Cmsg_tab%7C23431X%7C21812X%2C%2CisAuc%7Cyes%2Cmf%7C1&rr=0.33333&hitprm=msg_tab%3D23431X%7C21812X&pnLink=yes
http://www.ironplanet.com.au/for-sale/Utility-Vehicles-HONDA-TRX-420-2-WD-ATV-p%2Fb-HONDA-420CC-Gas-Eng%2C-24x10.00-11-Tire%E2%80%A6-Kansas/1084617?h=5002%2Cmsg%7C21831X%2Csm%7C0%2Cprows%7C100%2Csort%7Cln+asc%2Cmsg_tab%7C23431X%7C21812X%2C%2CisAuc%7Cyes%2Cmf%7C1&rr=0.25&hitprm=msg_tab%3D23431X%7C21812X&pnLink=yes
http://www.ironplanet.com.au/for-sale/Utility-Vehicles-2017-POLARIS-Sportsman-450-EFI-4-WD-ATV%2C-S%2FN-17180%2C-AT24x8-12-Ti%E2%80%A6-Montana/1084618?h=5002%2Cmsg%7C21831X%2Csm%7C0%2Cprows%7C100%2Csort%7Cln+asc%2Cmsg_tab%7C23431X%7C21812X%2C%2CisAuc%7Cyes%2Cmf%7C1&rr=0.2&hitprm=msg_tab%3D23431X%7C21812X&pnLink=yes
http://www.ironplanet.com.au/for-sale/KRUSE-SALES-ONLY-2017-CHEVROLET-2500HD-Service-Truck%2C-VIN-1GCOKUEY6HZ202865%2C-p%2Fb-%E2%80%A6-Montana/1084619?h=5002%2Cmsg%7C21831X%2Csm%7C0%2Cprows%7C100%2Csort%7Cln+asc%2Cmsg_tab%7C23431X%7C21812X%2C%2CisAuc%7Cyes%2Cmf%7C1&rr=0.16667&hitprm=msg_tab%3D23431X%7C21812X&pnLink=yes
http://www.ironplanet.com.au/for-sale/KRUSE-SALES-ONLY-2013-FORD-F-150-XLT-4-WD-Crew-Cab-Pickup%2C-VIN-1FTFW1EF3DKD07376%2C%E2%80%A6-Kansas/1084620?h=5002%2Cmsg%7C21831X%2Csm%7C0%2Cprows%7C100%2Csort%7Cln+asc%2Cmsg_tab%7C23431X%7C21812X%2C%2CisAuc%7Cyes%2Cmf%7C1&rr=0.14286&hitprm=msg_tab%3D23431X%7C21812X&pnLink=yes
http://www.ironplanet.com.au/for-sale/KRUSE-SALES-ONLY-2011-GMC-1500-4-WD-Extended-Cab-Pickup%2C-VIN-1GTR2TE30BZ167737%2C-p%E2%80%A6-Montana/1084621?h=5002%2Cmsg%7C21831X%2Csm%7C0%2Cprows%7C100%2Csort%7Cln+asc%2Cmsg_tab%7C23431X%7C21812X%2C%2CisAuc%7Cyes%2Cmf%7C1&rr=0.125&hitprm=msg_tab%3D23431X%7C21812X&pnLink=yes
http://www.ironplanet.com.au/for-sale/KRUSE-SALES-ONLY-1988-FORD-F-350-4-WD-Dually-Flatbed-Pickup%2C-VIN-2FDKF38MOJCB4807%E2%80%A6-Kansas/1084622?h=5002%2Cmsg%7C21831X%2Csm%7C0%2Cprows%7C100%2Csort%7Cln+asc%2Cmsg_tab%7C23431X%7C21812X%2C%2CisAuc%7Cyes%2Cmf%7C1&rr=0.11111&hitprm=msg_tab%3D23431X%7C21812X&pnLink=yes
http://www.ironplanet.com.au/for-sale/KRUSE-SALES-ONLY-1981-FORD-F-350-2-WD-Dually-Flatbed-Pickup%2C-VIN-1FDJF3720BKA4570%E2%80%A6-Kansas/1084623?h=5002%2Cmsg%7C21831X%2Csm%7C0%2Cprows%7C100%2Csort%7Cln+asc%2Cmsg_tab%7C23431X%7C21812X%2C%2CisAuc%7Cyes%2Cmf%7C1&rr=0.1&hitprm=msg_tab%3D23431X%7C21812X&pnLink=yes
http://www.ironplanet.com.au/for-sale/KRUSE-SALES-ONLY-2013-DODGE-Ram-2500-4-WD-Crew-Cab-Pickup%2C-VIN-3C6TR5CT8DG592066%2C%E2%80%A6-Kansas/1084624?h=5002%2Cmsg%7C21831X%2Csm%7C0%2Cprows%7C100%2Csort%7Cln+asc%2Cmsg_tab%7C23431X%7C21812X%2C%2CisAuc%7Cyes%2Cmf%7C1&rr=0.09091&hitprm=msg_tab%3D23431X%7C21812X&pnLink=yes
http://www.ironplanet.com.au/for-sale/KRUSE-SALES-ONLY-2013-WILRAY-T%2FA-Equipment-Trailer%2C-VIN-1W9BF1622DF397979%2C-8%272%22W-%E2%80%A6-Kansas/1084625?h=5002%2Cmsg%7C21831X%2Csm%7C0%2Cprows%7C100%2Csort%7Cln+asc%2Cmsg_tab%7C23431X%7C21812X%2C%2CisAuc%7Cyes%2Cmf%7C1&rr=0.08333&hitprm=msg_tab%3D23431X%7C21812X&pnLink=yes

<tbody>
</tbody>

Thanks in advance

Samuel Premanand