Forum Discussion
create link for a tab from one workbook to a cell on another workbook
Hi Can you inform me the correct way to link a tab in one workbook to a cell in a different workbook please
The easiest way:
- Open both workbooks.
- Select the cell where you want the link.
- Type =
- Switch to the other workbook, activate the correct sheet, then click on the cell you want to link to.
- Press Enter.
- Switch to the other workbook again, and close it (saving it if necessary).
- Finally, save the workbook with the link formula.
If you now look at the formula, you'll see its syntax:
='folderpath[workbookname]sheetname'!celladdress
Click on the sheet tab of the worksheet that contains the cell that you want to link to.