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

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