Jun 29 2022 08:47 AM
Hi All,
I have a spreadsheet we are using as an Executive dashboard which is data from multiple reports into one tab. We also have a need to have a link per row to go to a TAB in another spreadsheet. Basically, click the link, go directly to the named tab in another spreadsheet. I can find a way to link to a whole spreadsheet file or to a specific cell in the spreadsheet, but not just to a tab in a spreadsheet. Help?!? :)
Example:
Link in Cell C5 of spreadsheet A opens in spreadsheet B to the ABC tab
Link is Cell C6 of spreadsheet A opens in spreadsheet B to the DEF tab (same spreadsheet B as above)
Jun 29 2022 08:59 AM
By spreadsheet A and spreadsheet B, do you mean separate workbooks (files)?
Jun 29 2022 09:22 AM
SolutionOn the Insert tab of the ribbon, in the Links group, click Link, or press Ctrl+K.
Navigate to the folder with the other workbook, and select the workbook, but don't click OK yet.
Instead, click the Bookmark... button on the right.
Select the sheet you want to link to, and if you wish, specify the cell (the default is A1).
Then click OK, and OK again.
Jun 29 2022 10:49 AM
AWESOME! Thanks!! That totally worked.
Jun 29 2022 09:22 AM
SolutionOn the Insert tab of the ribbon, in the Links group, click Link, or press Ctrl+K.
Navigate to the folder with the other workbook, and select the workbook, but don't click OK yet.
Instead, click the Bookmark... button on the right.
Select the sheet you want to link to, and if you wish, specify the cell (the default is A1).
Then click OK, and OK again.