Recording changing cell

[GSP1976]

Hi guys

I have been struggling to find a solution to an excel problem I have. As the title says I have a cell in my spreadsheet that is constantly changing "H10" and I would like to record this for the last 5 seconds at 1 second intervals. But this would be triggered to start recording with another cell "C82" which will contain a "0" and a "1" to activate the recording. There is also another cell which will works the same way as the start trigger( 0 and a 1) and this sell is "C83". The recording cells are listed below.

now = I77
1 second ago = H77
2 seconds ago = G77
3 seconds ago = F77
4 seconds ago = E77
5 seconds ago = D77

I would like that thank anyone who helps or gives advice in advance.

 

[GSP1976]

Well... not really ...

The problem you are facing is that the way your cell is updated .... does not trigger any event ...

To understand what I mean ... just test a manual input into cell H10 ...

Ah I understand what you mean. I will try that, see what happens