Automatic Updation of data in my excel sheet

[supratik69]

I want to update my stocks portflio data by click of a button. At present I visit economic times website daily and update the datas in my excel sheet by copying and pasting the data one by one. This is a difficult task. Please help me

 

[Legacy 98055]

Help you with what? You have provided no relevant details... URLs, source data, destination ranges, ect...

 

[supratik69]

Help you with what? You have provided no relevant details... URLs, source data, destination ranges, ect...

Hi Tom

Thanks for writing in.
URL- http://economictimes.indiatimes.com/summary.cms?companyID=20738

source data= http://economictimes.indiatimes.com...ngeid=50&arc=0&pagenumber=0&pagesize=30&Go=Go

Destination ranges= A1-DATE, B1-DAY'S OPEN PRICE, C1-DAY'S HIGH PRICE, D1-DAY'S LOW PRICE, E1-DAY'S CLOSE, F1-VOLUME OF STOCK

Please help me.