How can I automatically copy a cell's value

[mmckeel]

I am trying to create a trend report for a real-time database. I have linked to the database and brought back the points. Then on the data toolbar I found a way to automatically refresh this data every 60 seconds. Would prefer a quicker update but doesn't seem to be an option. Let's say the data goes into cell C5. I need a way to move it to say cell d1 and then after the next scan move it to D2 then D3 and so on or even a new sheet. This will give me a range of cells to base my graph on without overwriting the data. Not to good with VBA. Any help would surely be appreciated. Thanks

 

[SkipVought]

Hi,

Please post in Forum707, because you WILL need VBA.

Skip,
[sub]
When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[/sub]