Auto-scroll an Excel workbook

DylanBrown You can do this with a bit of VBA code (paste into a normal module):

Option Explicit

Dim nextTime As Double

Sub scrollAgain()
    Dim curVisLastRow As Long
    curVisLastRow = ActiveWindow.VisibleRange(ActiveWindow.VisibleRange.Cells.Count).Row
        With ActiveSheet.ListObjects(1)
        If curVisLastRow < (.ListRows.Count + .Range.Cells(1, 1).Row) Then
            ActiveWindow.SmallScroll Down:=1
        Else
            ActiveWindow.SmallScroll up:=curVisLastRow - 1
        End If
    End With
    nextTime = Now + TimeValue("00:00:01")
    Application.OnTime nextTime, "scrollAgain"
End Sub

Sub StopScrolling()
    On Error Resume Next
    Application.OnTime nextTime, "scrollAgain", , False
End Sub

Start the scrolling by running the scrollAgain macro (alt+F8 from Excel, click on macroname and hit Run).

Stop it by running StopScrolling.

To make this slower, adjust the "00:00:01"

By the way: the code assumes your table is "Formatted as table".

Hello @DylanBrown
You definitely should start working in VBA. If you want to have all the fun that is.
On the Web there are plenty of examples of what you want to do, here are some examples:
https://forum.ozgrid.com/forum/index.php?thread/86754-scroll-screen-to-active-cell-row/
https://www.automateexcel.com/vba/scroll/
https://stackoverflow.com/questions/12636434/how-do-i-make-an-excel-worksheet-scroll-to-a-row-programatically

You could also write some code to remove the row of a completed task from the display.

Let me know if you need more help understanding the code or adjusting it to your needs.
TAKE THE PLUNG you will not regret it at all 😉

GiGi