Data Scrapping from Web Page

[Chandresh]

HI All,

Need a help for data scrapping from web page based on list that i have in excel sheet

1) Column A has list of web page - starting from Cell A2 to cell A10
Example
A2- Stock/Share Market Investing - Live BSE/NSE, India Stock Market Recommendations and Tips, Live Stock Markets, Sensex/Nifty, Commodity Market, Investment Portfolio, Financial News, Mutual Funds
A3- LIVE Stock/Share Market | Indian Stock/Share Market LIVE | S&P BSE SENSEX | BSE
2) Column B has table number which need to be extracted from web Page
Example
B2- Table 1
B3- Table 2
3) Column C has the destination were the extracted data should be pasted
Example
Sheet 2- Cell A1
Sheet 3- Cell A1

summarising - Stock/Share Market Investing - Live BSE/NSE, India Stock Market Recommendations and Tips, Live Stock Markets, Sensex/Nifty, Commodity Market, Investment Portfolio, Financial News, Mutual Funds table number 1 should be extracted and pasted in sheet 2 in cell A1
and it should do the same for all.

 

[Chandresh]

hi...could you please help