On another sheet, IF? the data is ALWAYS at cell b12, use =sheet1!b12
For a series use a looping macro to cycle thru or you can get all at once.
If you send an email to my address below I will send you a file that uses
Yahoo data.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Lamb Chop" wrote in message
...
I tried to web query but it only give me a whole table of data while I only
need the latest data only.

The data one I want to get from this page is the "Last Trade"

http://quotes.ino.com/chart/?s=NYBOT_DX


Any suggestion?

Thanks in advance.