Floating Table that scrolls

rcocrane99

New Member
Joined
May 9, 2024
Messages
35
Office Version
  1. 365
Platform
  1. Windows
Hello everyone, I want to make a table that will always be visible when scrolling down within a sheet, I could freeze panes but there are too many to freeze. I need to always see column H:N
1722345187585.png
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
You could open a new window (View, New Window) to the same file and open the windows side-by-side.
 
Upvote 0
No it's more of a convenience thing to make sure management can see it so I'd like to have it all in one of possible
 
Upvote 0
Although your picture does not appear to be a table, if it is indeed a table with the name of "Table1", then this code will work if you select a cell in the row where you want your Table to scroll to. The only other thing you have to decide is how you want to trigger the code. Perhaps double clicking a cell in the row that you want the table to move to or something else (in that case the code would have to put into the worksheet module) or a Command Button or something else.

VBA Code:
Sub Mtable()

    Dim i As Long, adr As String
    Dim ws As Worksheet: Set ws = ActiveSheet
    Dim tbl As ListObject: Set tbl = ws.ListObjects(1)
    Dim rw As Long
    
    i = ActiveCell.Row
    Range("Table1[#All]").Select
    adr = Selection.Address(False, False)
    rw = Selection.Row
    
    Selection.Cut Destination:=Range(adr).Offset((i - rw), 0)
    Range("A1").Select

End Sub
 
Upvote 0
do you know if this is something that can be implemented on a tablet as I know they cannto include macros not sure about VBA ( also to note i havent tried it yet as this will be my first time looking into VBA at all)
 
Upvote 0
Depends on the tablet. A Microsoft Surface tablet runs Windows, so it should work on that. If it isn't a Windows tablet, no VBA.
 
Upvote 0
Depends on the tablet. A Microsoft Surface tablet runs Windows, so it should work on that. If it isn't a Windows tablet, no VBA.
The table doesnt need to scroll on the tablet just whenever we use the computer.
 
Upvote 0

Forum statistics

Threads
1,224,465
Messages
6,178,820
Members
452,881
Latest member
motivationgyan

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top