Keeping changing values every set time period

[MrSpud]

Hi

Any help please
I am trying to record values every set time period eg 5 minutes, from COLUMN G and every second cell. Cells G9, G11, G13 etc to AG9,AG11,AG13 etc.
For example if it is 10.00am and value in G9 is 10 I want that value stored in AG9. Then at 10.05 if value in G9 is 11, I want that value stored in AG10. At 10.10 if value in G9 is 14 I want that value stored in AG11.

I hope that makes sense.

 

[MrSpud]

Any Help Please?

10.00 G9 value stored AG9 10.05 G9 value stored AH9 10.10 G9 value stored AI9 ETC



10.00 G11 value stored AG11 10.05 G11 value stored AH11 10.10 G11 value stored AI11 ETC


ETC FOR COLUMN G (ALTERNATE ROWS) 9, 11, 13 ETC