Hello All,

How can i change the cell reference when i sort the data with hyperlink?
For eg :- Below image consist data from A to C.
Cell Reference for hypelink C entered is A3.
When i sort the below Hyperlinks in descending order and C being now in cell A1, Cell reference still shows as A3.
How will it change automatically to A1?
Capture.JPG

Capture1.JPG

Capture2.JPG

Regards
Sid