What would it need to make the Excel scroll down and display the current time in center?
This is an example of how the sheet looks like and it's going for a whole week fluently.
Is there any way to write a script for that?
Help appreciated
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Time-Scrolling
- Thread starter Samzy86
- Start date
What would it need to make the Excel scroll down and display the current time in center?
This is an example of how the sheet looks like and it's going for a whole week fluently.
Is there any way to write a script for that?
Help appreciated
Excel Facts
What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
baitmaster
Well-known Member
- Joined
- Mar 12, 2009
- Messages
- 2,042
Welcome to the board
Please clarify, do you want this to be set up on a screen somewhere, and regularly update so that in effect every half hour the screen scrolls by 1 row? Or just centres on the current time when you open the workbook / select the worksheet?
Please clarify, do you want this to be set up on a screen somewhere, and regularly update so that in effect every half hour the screen scrolls by 1 row? Or just centres on the current time when you open the workbook / select the worksheet?
Upvote
0
Similar threads
- Question
