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!