Hi guys,
I'm trying to have a kind of recorder that copies A1 into B1 every 15 seconds. The next time it copies A1 into B1 again, I want the previous B1 to go to C1. This cascade goes on until E1, where the next time the "copying" happens, E1 gets erased.
Basically after 60 seconds, A1:E1 are populated. After 75 seconds, A1 value goes to B1 (the copying), B1 value goes to C1, C1 value goes to D1, D1 value goes to E1, and E1 value is erased. There is from then on always 5 values in those 5 cells.
Here is an example of how the cells in row 1 would look like over time:
During 15 seconds:
1 2 3 4 5
2 2 3 4 5
8 2 3 4 5
7 2 3 4 5
5 2 3 4 5
After 15 seconds:
1 5 2 3 4
3 5 2 3 4
8 5 2 3 4
0 5 2 4 5
Etc.
Also, I will probably do this for the second row, third row, fourth row, etc. I don't know if it's important to know but A1, or the values in the first column, constantly change throughout the day.
Thanks in advance guys, you have always been very helpful.
I'm trying to have a kind of recorder that copies A1 into B1 every 15 seconds. The next time it copies A1 into B1 again, I want the previous B1 to go to C1. This cascade goes on until E1, where the next time the "copying" happens, E1 gets erased.
Basically after 60 seconds, A1:E1 are populated. After 75 seconds, A1 value goes to B1 (the copying), B1 value goes to C1, C1 value goes to D1, D1 value goes to E1, and E1 value is erased. There is from then on always 5 values in those 5 cells.
Here is an example of how the cells in row 1 would look like over time:
During 15 seconds:
1 2 3 4 5
2 2 3 4 5
8 2 3 4 5
7 2 3 4 5
5 2 3 4 5
After 15 seconds:
1 5 2 3 4
3 5 2 3 4
8 5 2 3 4
0 5 2 4 5
Etc.
Also, I will probably do this for the second row, third row, fourth row, etc. I don't know if it's important to know but A1, or the values in the first column, constantly change throughout the day.
Thanks in advance guys, you have always been very helpful.
