Hi
Plese help me out with this one.
I want to import data from a website (2 are from website page table) and 2 are from csv file from web.
Here it goes
The workbook has 3 sheets
Sheet 1 : will download data from "http://www.nseindia.com/content/equities/bulk.csv"
-> csv file will be delimited
-> sorted Assending by "Symbol" Coloumn B
Sheet 2 : Bulk Deal table from the link should get copied from "http://www.bseindia.com/markets/equity/EQReports/bulk_deals.aspx?expandable=3"
-> same formating as in sheet 1 and should be sorted by Coloumn B
->
Sheet 3 :will download data from "http://www.nseindia.com/content/equities/block.csv"
-> csv file will be delimited
-> sorted Assending by "Symbol" Coloumn B
-> Block Deal table from the link should get copied"http://www.bseindia.com/markets/equity/EQReports/block_deals.aspx?expandable=3" from the point the table ends after downloading data from "http://www.nseindia.com/content/equities/block.csv"
Thanks a ton in advance
Wasim Anjum
Bookmarks