Question Locked

excel - keep previous cell data

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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...

1 reply

This discussion is closed to new replies.