Hyperlinks and AutoFilter
 

When the user uses an autofilter, the hyperlinks (in a separate column) do
not sort with the rest of the data. The hyperlinks move, but don't hold with
data in the same row. Any ideas on a fix?