Hello,
I am having a problem with Excel where I am using the filter function to display a range of cells depending on a dropdown list where I select certain text. Everything works except the range of cells contain hyperlinks which are not working anymore when the filter function is used. Is there any solution to keep the hyperlinks working?
When I select 2C as Airline it copies the range of cells in below image but for some reason MENZIES cannot be clicked anymore as hyperlink.
Bookmarks