Real-Time Data Printout Sheet

[greyfox45]

Ok, this will be very hard to describe so bear with me.

I am linking my excel to a website that updates a set of numbers ever
hour. I have discovered how to link my excel to the website (for mor
information on that see http://tinyurl.com/2eash) BUT everytime th
data refreshes it replaces the old data.

Here's exactly what I want to figure out. I want to store the copy th
data that was retrieved into a separate sheet everytime it i
refreshed. After an hour has passed and new data is retrived (let
call it data 2), I want to take data 2 and store a copy of thos
numbers into a separate sheet as well before refreshing the next set o
data, e.g. data 3 (hour 3).

The major problem, how do I get it to simultaneously cycle through th
data and at the same time paste it in separate areas on a separat
worksheet?

If you can help me figure this out, I will be forever indebted to you.

Thanks

Grant K

 

[Ayrin]

Would this work:
start timere
if timer minutes = 0 then exeRefresh(time)


function exeRefresh(time as string)
create worksheet_time (ie data_08:00)
copy activeworksheet all cells paste as worksheet_time
activeworksheet refresh data
end

Obviously this is not code, but if this would work and you need more help
with the actual functions, let me know.

Ayrin