Post by: MadHatter on December 20, 2008, 12:41:25 PM
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.
(http://img78.imageshack.us/img78/860/scr8605404sr3.jpg) (http://\"http://imageshack.us\")
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.
Post by: guestolo on December 21, 2008, 12:55:27 PM
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/ (http://\"http://www.excelforum.com/\")
OR
http://www.mrexcel.com/forum/forumdisplay.php?f=10 (http://\"http://www.mrexcel.com/forum/forumdisplay.php?f=10\")
There may be others, so your choice
Post by: MadHatter on December 21, 2008, 05:14:51 PM
/wink.gif\' class=\'bbc_emoticon\' alt=\';)\' />
Post by: newbiz02 on December 31, 2008, 01:30:07 PM
/wink.gif\' class=\'bbc_emoticon\' alt=\';)\' />[/quote]thanks mate, i appreciate that
/biggrin.gif\' class=\'bbc_emoticon\' alt=\':D\' />