excel - keep previous cell data

By evalweb ·
I have a cell A1 that is updated every 5 seconds from data I receive from a DDE server (those data are just numbers between 0 and 10)

What I need is to store every minute the number from A1 in order to keep historical data of those numbers.

So let say at 8:00, A1 number is copied in C2 cell and kept, at 8:01 A1 number is copied in C3 cell and kept, at 8:02 A1 number is copied in C4 cell and kept...
so basically I need 2 or 3 columns
column A is just for A1 values that changes every 5 seconds or so
column B is the time with an increment of 1mn
column C is the value of A1 at the time in B like a snapshot at a specific time....

Is there any command or formula or macro to do that... and if yes how...

Hope you can help me...

This conversation is currently closed to new comments.

0 total posts (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Networks Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums