Import website data into excel (Scrapping of data)

[excel_1317]

I have a tedious task of copy/paste from our website. Please have a look at below sample data. I have around 1500 rows of data like this.


Sheet1[TABLE="class: html-maker-worksheet"]
<thead>[TR]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[/TR]
</thead><tbody>[TR]
[TH]1[/TH]
[TD]Command Line[/TD]
[TD]No. of results returned[/TD]
[/TR]
[TR]
[TH]2[/TH]
[TD]((pa:"DR. ROBERT A. LEVINE*") and pd>2008) not lgrp:nif[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TH]3[/TH]
[TD]((pa:"Synthetic Env Inc DBA Eye Talk Sys*") and pd>2008) not lgrp:nif[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]4[/TH]
[TD]((pa:"Easton Sports*") and pd>2008) not lgrp:nif[/TD]
[TD="align: right"]159[/TD]
[/TR]
[TR]
[TH]5[/TH]
[TD]((pa:"ENTERTAINMENT GAMING ASIA *") and pd>2008) not lgrp:nif[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]6[/TH]
[TD]((pa:"Developmental Technologies*") and pd>2008) not lgrp:nif[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]7[/TH]
[TD]((pa:"S & S Concepts*") and pd>2008) not lgrp:nif[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]8[/TH]
[TD]((pa:"ArrayNetworks*") and pd>2008) not lgrp:nif[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TH]9[/TH]
[TD]((pa:"PACIFIC LAW GROUP*") and pd>2008) not lgrp:nif[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]10[/TH]
[TD]((pa:"Nite Ize*") and pd>2008) not lgrp:nif[/TD]
[TD="align: right"]94[/TD]
[/TR]
[TR]
[TH]11[/TH]
[TD]((pa:"EPIVAX*") and pd>2008) not lgrp:nif[/TD]
[TD][/TD]
[/TR]
[TR]
[TH]12[/TH]
[TD]((pa:"CeNeRx BioPharma*") and pd>2008) not lgrp:nif[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Excel 2010



Column A has input data which i need to copy and paste in a web form. Column B will have results scrapped form webpage(http://tinyurl.com/ls2m98o). This webpage will need login details. Please PM me for login details.

If a code can be written which take value form column A of spreadsheet and paste in webpage like shown in above image and hit search button. Next webpage will be loaded with number of results like shown in below. Take the number of results and paste in column B of spreadsheet.

 

[excel_1317]

I have posted this query on other thread because NO response received yet. I have uploaded screenshot image with login details on other forum.