Hello,
I have a spreadsheet and one of the columns is all hyperlinks with display text. They all work fine, but when i filter on the column headers it appears that the hyperlink stays with the original cell rather than with the filtered cell.
For instance,
lets say i have 5 columns and 10 rows
in A1 the value is 1 and in G1 the value is text "blah" with a defined hyperlink to www.blah.com.
lets say that in A10 the value is ten and in G10 the value is text "fubar" with a defined hyperlink to www.fubar.com

When i filter on A sorting largest to smallest, row A1 now has value of ten and G1 has text of "fubar" but the hyperlink points to blah.com instead of fubar.com

Any ideas how to correct this?
Thanks,