Forum Discussion
Solved
Link to a Tab in a spreadsheet
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 spreadshee...
On 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.
Yes, completely separate files.
On 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.
AWESOME! Thanks!! That totally worked.