How to extract one data from a website

[Lamb Chop]

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.

 

[Don Guillett]

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.