@carlfse435
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
