Hi All,

I am looking to make a hyperlink mapping of cells from one sheet to another.

Specifically, I have a list of 90 unique names, each name appearing once in each of two sheets. Sheet1 shows the names listed in a column in no particular order (the names can be rearranged/sorted); In sheet2, the names are allocated into 90 cells representing ten 3x3 matrices, and the cell locations of the names are fixed (cannot be sorted/rearranged). I want to make every name in sheet2 a hyperlink that maps to its matching pair on sheet1 -- I can do this manually by writing the cell locations, but I was wondering if anyone could direct me on how to go about making Excel find the matching pair and create a hyperlink.

Any suggestions are appreciated.

Thanks,
Juan