I build a very long page with many tables. The layout needs to remain this way for various reasons, but the tables themselves fall under different categories. What I'm asking is if there's a way to create a button (or any other solution) that by clicking it the view will jump to a specific section of the sheet, (something like you will see in many websites) ?
you can create a button, then make it activate a variable something like =if(vShow=1,0,1)
and on the table layout you chose the condition that shows the table
setting variables is under setting-->variable overview
hope that helped
You should separate your objects in several sheets. Within the sheets you could put the objects one above the other and controled the visibility per variable (settings in layout) and/or put the opbjects in container-boxes which could also be nested. This could you control per macros or actions in buttons which choose the sheet or perhaps bookmark and/or set variable-values and so on. If you have any scroll-bars the usability isn't really good ...
All, thanks for trying to help.
What I have is one long sheet with many pivot tables one below the other.
This has to remain the format.
I cannot break it to different sheets or to use conditional show/hide.
That's why I asked how I can get a "jump to" functionality, for places within the same sheet.