Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to save a snapshot of data?
I have a range of 30 cells that are linked to an outside source that is
updating them in 10 second cycles. I also have a cell that counts the accumulating cycles. I have a line chart that shows me the cell variation in real time. I would like to take a sample of the values in those 30 cells once every 10 thousand cycles and save them to another sheet so that I can chart change trends over the long term. Doe anyone have an example of how I could do this? Regards, Dustin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to save a snapshot of data?
Assuming that you have code that runs at every update, include a call to:
CycleCheck() then enter Sub CycleChecker() cyclecounter=cyclecounter + 1 if cyclecounter=10000 then cyclecounter=0 ' insert logic to do transfer end if end sub You will need to Dim cyclecounter as long outside the sub to make it static. This is un-checked code -- Gary's Student "DustinS" wrote: I have a range of 30 cells that are linked to an outside source that is updating them in 10 second cycles. I also have a cell that counts the accumulating cycles. I have a line chart that shows me the cell variation in real time. I would like to take a sample of the values in those 30 cells once every 10 thousand cycles and save them to another sheet so that I can chart change trends over the long term. Doe anyone have an example of how I could do this? Regards, Dustin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to Save data | Excel Worksheet Functions | |||
Rolling up a snapshot of data by month | Excel Discussion (Misc queries) | |||
Save A Worksheet as a Snapshot File | Excel Discussion (Misc queries) | |||
need a function (not macro with ontime) to record a snapshot of a changing cell | Excel Programming | |||
Viewing Snapshot Files with Snapshot Viewer Control on Excel Userform...How? | Excel Programming |