View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DustinS DustinS is offline
external usenet poster
 
Posts: 3
Default 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