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 out, non visible cells in between the the cells that I wish to add links to also get linked. They do NOT get text added to them or modified, but they absolutely get a link added. How can I avoid this?