I've created a primitive program using three linked sheets to access information. However, when I click on a link to navigate between sheets, I want to land in the center of the relevant section, not at a random spot.
For instance, when I click a link to go from sheet A to sheet B, it's easy to accidentally scroll up, down, or sideways. If I then return to sheet A and re-enter sheet B through the link, I'll end up at the wrong cell.
I know how to hide unused rows and columns, but that doesn't solve the issue of focusing on the correct cell when I click the link.
Can anyone help me find a solution to this problem?