Multiple Freeze Pane rows as you scroll

[sr7]

Hi! I am trying to figure out a way to change the freeze pane of a spreadsheet as you scroll down the page.

I have a range with header rows on rows:

Row 2
Row 30
Row 65
Row102


I would like to have the ROW 2 header frozen as you scroll through rows 2-29, then switch to freeze at row 30 (while hiding rows <30) while scrolling thourhg/working in rows 30-64, and so on.


Any thoughts?

 

[footoo]

Freezing a header row until another header scrolls on screen

Is there a way for a row functioning as a header to freeze, but then be replaced by another header row as it scrolls on to screen? In my example I've got a section called "Benefits", then about 20...

superuser.com