Getting live datas from webpage to Excel Sheet

[navino87]

I just want to know whether is it possible to get live data from a webpage to excel sheet i.e.,


http://content.icicidirect.com/resea...gory=corporate

This is the live quotes page from ICICI direct. And the stock name is ICICI.

I want to get only that marked figure i.e. 61.25 to excel sheet.

Is it possible to get it???

Thanks in advance...

[subratabera]

Data --> Get External Data --> Paste URL --> Select Table --> Select update Interval.

[navino87]

^^^thank u man...

If we do this the entire table is selected.... I just want that particular data...

Is it possible to do so???

[hailgautam]

you need to get the entire data on one sheet and then link it to the desired cell on your main sheet.