Thanks for your time mate. Attached is a sample workbook. Now when i sort the data as per descending order cell reference wont change. For eg data is from A to H, Right click on H - edit hyperlink - Type in cell reference A8. On sorting the data, H now being in cell A1 i need to direct this to A1 automatically and not A8.
Hyperlink.xlsx