In Google Sheets, I have two completely separate spreadsheet files. In Spreadsheet A, there is a cell with a link to open Spreadsheet B, and vice versa. When I click on the link, the other Spreadsheet opens up just fine. However, it opens up in a new tab. Is there a way to make it open in the same window that I'm working in?
If I understand correctly, you have a single spreadsheet with two sheets, and you want to add a link in a cell in Sheet A that switches the active view to Sheet B.
You can find the gid for Sheet B by switching to the sheet in the browser window, and look for the
gid= term at the end of the URL. All Google Sheet URLs take the form