I have a sheet with an Excel table on it which users add to the bottom off periodically, over a year. It ends up being at least three or four screens high.
Also on the sheet it a Pivot Table of selected data from the table and a Command button to run some vba every couple of months.So when the table becomes larger than a screen the Pivot Table and Command button disappear off the top.
Is there a neat way of having the Pivot Table and Command button floating so they stay in view and are usable?
I have tried splitting the screen and it kind of works but isn't quite what I was looking for.