Jan 20 2022 08:56 AM
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...
Jan 20 2022 12:19 PM
No access to the file
Jan 20 2022 12:26 PM
Jan 20 2022 01:28 PM
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.