First post here. I pride myself at being excellent with excel, however this one has me stuck. I feel like I've tried everything and need some help here.

Let me start by saying I'm not 100% if this is even possible. Seems like it should be since it's not too crazy, but can't find any solutions on google.

I have a spreadsheet that has 2 tables on it place directly above and below each other with with the same number of columns, but with different table titles (since the data is from two different sources). The labels for Table A are in row1 and 2, and the labels for Table B are in 60 and 61. I know how to freeze pane to make the two labels in Table A appear when scrolling, but I want them to disappear and be replaced with the labels from Table B (rows 60 and 61) when I scroll down below that and have those two now at the top. And when I scroll back up to my top table, have Table A labels re-appear. Relatively similar to how some websites are when you are scrolling down and the title is replaced by the one below it when you scroll far enough to the next section.

The Sheet would appear as below except with more rows and columns. But for simplicity you can see how the tables are above and below one another.

---------------------Table A----------------------
Cat. 1 | Cat. 2 | Cat. 3 | Cat. 4 | Cat. 5 |
--------------------------------------------------
Week 1 | 10 | 11 | 6 | 5 |
--------------------------------------------------
Week 2 | 12 | 4 | 8 | 11 |
--------------------------------------------------
Week 3 | 5 | 13 | 10 | 4 |
--------------------------------------------------
Week... | 7 | 10 | 3 | 9 |
--------------------------------------------------
Week 52 | 13 | 11 | 4 | 8 |

--------------------------------------------------
-------------------(blank rows)-------------------
--------------------------------------------------

---------------------Table B----------------------
Cat. 1 | Cat. 2 | Cat. 3 | Cat. 4 | Cat. 5 |
--------------------------------------------------
Week 1 | 10 | 11 | 6 | 5 |
--------------------------------------------------
Week 2 | 12 | 4 | 8 | 11 |
--------------------------------------------------
Week 3 | 5 | 13 | 10 | 4 |
--------------------------------------------------
Week... | 7 | 10 | 3 | 9 |
--------------------------------------------------
Week 52 | 13 | 11 | 4 | 8 |


Is there a way for me to have Table A and it's categories (row 1 and 2) displayed via freeze pane (or another method) until I scroll down past rows 60 and 61 to Table B and it's categories (row 60 and 61) to have them displayed via freeze pane?

I'm open to any options even if some are outside of the box (or if its a simple solution and I'm just missing it).