Forum Discussion
Link to a Tab in a spreadsheet
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.
By spreadsheet A and spreadsheet B, do you mean separate workbooks (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.