Creating Multiple Scroll Ranges on a Sheet

Hi,

I am working on a sheet that has a pivot table containing hours, as well as calculation of labor costs based on those hours. Now, the pivot table is constantly going to be refreshed as hours are inputted daily. So the size of the pivot table is going to increase beyond the 46 rows that are visible at any one time on the screen. In order to see both the hours and the labor costs simultaneously, I am going to insert a split in the worksheet.

The pivot table will be between rows 1 and 1500. I am going to situate the calculation of the rates between rows 2000 and 2100. I was wondering if there is any way to create these two scroll ranges in the same sheet. Also, I am wondering if this is possible, considering that in order to get to 2000, you need to scroll past 1500. Therefore, I am not sure is "scroll" is the correct word I should be using. Essentially then, I am trying to limit the cells that can be viewed to the above 2 ranges.

Is there a code that I can put into the worksheet to accomplish this?

Thank you all in advance for your help!

I'm not entirely sure I follow, but if I do:

If you create a new window (Window- New Window, then Window - Arrange...), you can choose to centre each window (on the same workbook) on the specific ranges you're interested in.

I think the next logical step is saving workspaces... I've never really used them but from my understanding this will return the layout you've arranged when you reopen the spreadsheet.

Perhaps I'm going in the wrong direction?

HTH