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…
