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!
Edited by Radukes07, 20 December 2008 - 12:41 PM.