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

Copper 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.