Keeping a link live in a workbook when using the FILTER function. HELP!!

%3CLINGO-SUB%20id%3D%22%5C%26quot%3Blingo-sub-3067305%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3EKeeping%20a%20link%20live%20in%20a%20workbook%20when%20using%20the%20FILTER%20function.%20HELP!!%26lt%3B%5C%2Flingo-sub%26gt%3B%3CLINGO-BODY%20id%3D%22%5C%26quot%3Blingo-body-3067305%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CP%3EHi%20All%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20keep%20a%20link%20live%20when%20using%20the%20FILTER%20function%20but%20when%20the%20information%20is%20transferred%20to%20to%20a%20separate%20tab%20the%20link%20no%20longer%20stays%20live.%20Is%20there%20a%20way%20to%20keep%20the%20link%20live%20when%20the%20FILTER%20function%20is%20used%3F%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3ESee%20the%20workbook%20link%20below.%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EThanks%2C%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26lt%3B%5C%2FP%26gt%3B%3C%2FP%3E%3CP%3EWorkbook%20Link%3A%26nbsp%3B%20%26nbsp%3B%3CA%20href%3D%22%5C%26quot%3Bhttps%3A%2F%2F1gman-my.sharepoint.com%2F%3Ax%3A%2Fg%2Fpersonal%2Fmegan_gerany_onegm_com%2FEXojm9ulYUZGmRtrM_d80koBwcRVG3bWnmWJLNKM6CGyeA%3Fe%3DTFbg8Z%5C%26quot%3B%22%20target%3D%22%5C%26quot%3B_blank%5C%26quot%3B%22%20rel%3D%22%5C%26quot%3Bnoopener%20nofollow%20noopener%20noreferrer%22%20nofollow%3D%22%22%20noreferrer%3D%22%22%3Ehttps%3A%2F%2F1gman-my.sharepoint.com%2F%3Ax%3A%2Fg%2Fpersonal%2Fmegan_gerany_onegm_com%2FEXojm9ulYUZGmRtrM_d80koBwcRVG3bWnmWJLNKM6CGyeA%3Fe%3DTFbg8Z%26lt%3B%5C%2FA%26gt%3B%26lt%3B%5C%2FP%26gt%3B%26lt%3B%5C%2Flingo-body%26gt%3B%3CLINGO-LABS%20id%3D%22%5C%26quot%3Blingo-labs-3067305%5C%26quot%3B%22%20slang%3D%22%5C%26quot%3Ben-US%5C%26quot%3B%22%3E%3CLINGO-LABEL%3EExcel%26lt%3B%5C%2Flingo-label%26gt%3B%3CLINGO-LABEL%3EFormulas%20and%20Functions%26lt%3B%5C%2Flingo-label%26gt%3B%26lt%3B%5C%2Flingo-labs%26gt%3B%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3C%2FLINGO-SUB%3E
Occasional Contributor

Hi All,

 

I am trying to keep a link live when using the FILTER function but when the information is transferred to to a separate tab the link no longer stays live. Is there a way to keep the link live when the FILTER function is used? 

 

See the workbook link below.

 

Thanks,

 

Workbook Link:   https://1gman-my.sharepoint.com/:x:/g/personal/megan_gerany_onegm_com/EXojm9ulYUZGmRtrM_d80koBwcRVG3...

3 Replies

@megangeranyonegmcom 

So far could suggest only to add helper spill to the right of filtered data with

=HYPERLINK( INDEX( A2#, 0, 15) )

Links work, the only they are not formatted as links.