Hi All,
I hope that you are all well and safe.
Is there a way to have the scrollbar (in cell H31 as shown in the attached file) to display the texts or non-empty cells furthest to the right of the referenced rows (rows H7 to H30) of which it displays using a command button?
i.e. the cells controlled by the scrollbar in sheet 1 to display the final text furthest to the right (last column with text) in sheet 2, and whenever I add more text to the right to have the scrollbar move simply by pressing a command button to display those last texts?
Bookmarks