Formula to return/display the contents of a particular cell from the active row

[jahsquare]

Hi,
I have a huge table with many (> 8000) rows. Each row has a group of static data (each of which includes sizeable blobs of text, which I have to view via the formula box at the top of the sheet) and a group of dynamic cells, which I edit as I read the static data. Typically I click on a static cell, read/analyze the data, then click over to the appropriate dynamic data cell and edit as needed.

The problem is that I have to use the formula box at the top to read the blobs of static text, and so I waste a lot of time clicking back and forth, because that static data does not remain displayed when I click over to the dynamic cells.

What I'd like to do is use the split-screen feature or some kind of dialog to display the static data no matter which cell in the active row is currently selected. Then I can bounce around to fill in my dynamic data, and the static text will remain on-screen. This will also allow me to move up and down through the rows more easily. Basically I would have the table visible on the left side of the screen, and on the right side in a split-window I would have the static data displayed from the active row.

Is there any simple way to do this?

Many thanks!

 

[NeonRedSharpie]

Was able to get that to work, though it is not any faster:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   Target.Calculate
   Dim x As Long
   For x = 1 To 5
       With Cells(8214 + x, 61)
           .Value = Cells(Target.Row, x)
       End With
   Next
   End Sub

Not sure this is the best bet, as now there's about a 5-7 second delay with each selection change. The table is just too big, I suppose.
Anyway, thanks for your time!

You could turn calcs off while it's retreiving the value. Something like:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    Application.ScreenUpdating = False
    Application.DisplayAlerts = False
    Application.Calculation = xlCalculationManual
    
        Target.Calculate
        Dim x As Long
            For x = 1 To 5
                With Cells(8214 + x, 61)
                    .Value = Cells(Target.Row, x)
                End With
            Next
    
    Application.ScreenUpdating = True
    Application.DisplayAlerts = True
    Application.Calculation = xlCalculationAutomatic


End Sub

 

[jahsquare]

You could turn calcs off while it's retreiving the value. Something like:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    Application.ScreenUpdating = False
    Application.DisplayAlerts = False
    Application.Calculation = xlCalculationManual
    
        Target.Calculate
        Dim x As Long
            For x = 1 To 5
                With Cells(8214 + x, 61)
                    .Value = Cells(Target.Row, x)
                End With
            Next
    
    Application.ScreenUpdating = True
    Application.DisplayAlerts = True
    Application.Calculation = xlCalculationAutomatic


End Sub

This is excellent, it's back at about 1/2 sec delay, the container cells update near-instantly. Thanks for the hints.