| 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 |
| 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 | |||
Threaded Mode
