Forum Discussion
Hyperlinking multiple filtered cells
I filter out a column to show only cells that have a certain value, and then I wish to add a simple hyperlink (right click, link) to a separate PDF document. When I do this, all of the filtered ...
Here is an example of an external reference formula in Excel:
=HYPERLINK("[Path]FileName!Cell","DisplayText")
Replace [Path] with the path to the workbook that contains the cell you want to reference. Replace FileName with the name of the workbook and Cell with the cell address. Replace DisplayText with the text you want to appear in the hyperlink.
I hope that helps!