Excel 2007 Web Query question/help

[MadHatter]

Hi everyone.

I have set up a web query to refresh data every minute, however the data refreshes in the same cell so I am unable to track the data in say a line graph.  Also, is it possible to get time stamps in the Cells next to it every time the data refreshes? I will provide some screen shots.




Ok, look at cell B1, I set it up so that data refreshes every minute, but every time it refreshes it only refreshes in cell B1, how can I make it so that every time I refresh the new data will be put into B2, and then B3, and then B4 and so on and forth. Also, is it possible to put time stamps in the A cells every time this data is refreshed? If so, how?

Thank you for the help!



I posted this on another forum so if it sounds like im posting for the first time then thats why.

[guestolo]

Hi MadHatter, I'm no Excel guy
and the wife is outta town for awhile so I can't pick her brain on the subject

If your not getting much help here, or at Bleeping computers forum
May I suggest that you try a forum dedicated to Excel
This one seems very busy, and it looks like most topics do get a reply, just need patience
http://www.excelforum.com/
OR
http://www.mrexcel.com/forum/forumdisplay.php?f=10

There may be others, so your choice

[MadHatter]

Thanks. You never let anyone down. http://images.thetechguide.com/forum/public/style_emoticons/<#EMO_DIR#>/wink.gif\' class=\'bbc_emoticon\' alt=\'\' />

[newbiz02]

[quote name=\'MadHatter\' post=\'452047\' date=\'Dec 21 2008, 04:14 PM\']Thanks. You never let anyone down. http://images.thetechguide.com/forum/public/style_emoticons/<#EMO_DIR#>/wink.gif\' class=\'bbc_emoticon\' alt=\'\' />[/quote]


thanks mate, i appreciate that  http://images.thetechguide.com/forum/public/style_emoticons/<#EMO_DIR#>/biggrin.gif\' class=\'bbc_emoticon\' alt=\'\' />