I want to find an automated way so that the line moves one cell across at a certain time every day (6 am). So, if the orange line is after the number 1 today, I am expecting it to be after the number 2 at 6 am tomorrow (as shown in image below). At 6 am the following day, I am expecting to see it move after the number 3. And so on. So I am expecting it to move across by 1 cell at that specific time every day. Any suggestions on how to do this in excel vba would be appreciated.

Capture.PNG