Record Values of cells at intervals

[Pavertheway]

Hi,

I have a spreadsheet that in cell A1, has a percentage value that is constantly changing based on different data being inputted into the sheet.
Is there a way for each time that a change log is registered in that cell, for the cell value to be copied into cell A4. Then the next time there is a change, for the new value to be copied into cell A5, and so on.
So each time A1's value changes, it records the new value, and keeps a log of all the values over time.

Is there a way that I can do this, or will it have to be user inputted?

Thanks

 

[Pavertheway]

That's great.
Thank you so much! That's working perfectly; then I can apply it to each sheet to do the same task over and over, and use it to measure the percentage values over a time period - you've saved me so much time!

Thank you

 

[Joe4]

You are welcome!
Glad I was able to help.