Relative Hyperlink

[doug.washburn]

Hello,

I want to create a hyperlink on a worksheet that takes you to another cell relative to the cell the user happens to be on.

For example, if you are on a cell in row 5, the hyperlink takes you to AA5. If you are on row 12, it takes you to AA12. Always the same column (AA) but relative to the row you are on.

Any suggestions?

 

[schielrn]

This is one way:

=HYPERLINK("["&SUBSTITUTE(LEFT(CELL("filename",A5),FIND("]",CELL("filename",A5))-1),"[","")&"]'"&MID(CELL("filename",A1),FIND("]",CELL("Filename"))+1,32)&"'!AA"&ROW(),"AA"&ROW())

Hope that helps.