Hey folks. Little difficult to explain, but a picture should help. Basically, I want to freeze/split a portion of a worksheet to act as an on-screen table of contents. The idea would be that the stuff on the left is always locked and visible and clicking it pulls up the needed chart on the right. So in the example below, if you click link 03 I want to jump to chart three on the right on row 53 on the right pane but keep the left pane locked where it is. The idea would be someone can just click the links on the left to jump to whichever chart they want without those links ever jumping around. Hyperlinking to the chart areas is no problem, but I can't get the left table of contents to stay put while right pane jumps to the charts. So in essence the question is "Can I force excel to show different rows in different split panes?"
I've fiddled around a bit (and googled a lot) and wasn't able to find a working example of this. It might be I am trying to force a functionality beyond what excel is designed for, so I am hoping you can set me straight if so. Link to the file in case helpful (it is literally just what you see in the picture). https://drive.google.com/open?id=1CrEIzoovBI3Tgs6tUFbAIIOVKrTFnTsR
Thanks for any help!
I've fiddled around a bit (and googled a lot) and wasn't able to find a working example of this. It might be I am trying to force a functionality beyond what excel is designed for, so I am hoping you can set me straight if so. Link to the file in case helpful (it is literally just what you see in the picture). https://drive.google.com/open?id=1CrEIzoovBI3Tgs6tUFbAIIOVKrTFnTsR
Thanks for any help!
