Freeze Multiple Panels

[Ottsel]

Would it be possible to have multiple frozen panels within the same sheet?

For example:

Row 2 I have a header that I would like to display until row 247, which a new table will appears and the frozen header from row 2 will be replaced with the header from row 247 UNLESS I or the user scrolls back up past row 247. Then frozen panel/section would re-display the header from row 2.

Wasn't quite sure if this is possible. Unlikely, but figured I'd ask. Was struggling researching it on the web. Either its not possible or I wasn't searching with the correct string of words.

Any help, tips or tricks is greatly appreciated! Thank you.

 

[Automatrix]

I don't believe so. Better to have the tables in two different sheets, as this will also allow you to expand table 1 without having to worry about overlapping with table 2.

 

[Peter_SSs]

Not sure, but I wouldn't be surprised if @Jaafar Tribak has a suggestion for you.