SOLVED

Link to a Tab in a spreadsheet

New Contributor

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)

4 Replies

@MarcWaddell 

By spreadsheet A and spreadsheet B, do you mean separate workbooks (files)?

Yes, completely separate files.
best response confirmed by Sergei Baklan (MVP)
Solution

@MarcWaddell 

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.

@Hans Vogelaar 

AWESOME! Thanks!! That totally worked.