I'm not sure how to phrase this request but I hope you understand.
Can someone tell me if its possible to have Excel move the value of a cell to another cell in a specified time.
Let me explain
Lets say a calculation has been completed in cell K3 I would like the value within K3 to move to L3 in 15min intervals. So, lets say the value of the cell in K3 was 10 at 15:15pm I would like that value to move to L3. And lets say the time now is 15:30pm and the value of the cell in K3 is now 23, I would like that value to replace the old value 10 in cell L3
I bet you excel experts haven't had a question like that before :-)
Can you please let me know if it possible, and if it is how do I make it happen?