To create a hyperlink to an existing file or web page, follow these steps:
In the Insert menu click Hyperlink.
The Insert Hyperlink window will open.
Under Link to to the left side click Existing File or Web page.
To link to a file, Under Look in select Current Folder, then select your folder or file from the [...]
There is no automatic way to find links used in a workbook. However links use brackets [ ] to enclose the source workbook name, and it also uses the exclamation mark at the end of the sheet name in the link. So you can search for one of these two symbols depending on what type [...]
If you want data from one worksheet to be linked to, or shown in another worksheet then follow these steps:
In the sheet you want to link to (source) select the cell where the value is.
Right click and select Copy.
In your main sheet (target), select the cell where the value is to be displayed.
Right [...]
