How do I import single bits of data? I want to import NYSE volume into one cell and have it up date automatically. The URL I use is http://online.wsj.com/mdc/public/page/2_3021-tradingdiary.html?mod=topnav_2_3000. Please comment.
Reply from Richard Rost:
Richard, the easiest way to handle this situation is to just import the entire table of data into a "scratch" sheet, and then copy/paste-link the cell data that you want into another sheet. This way you can pick and choose the bits of information that you want in your REAL sheet.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.