Hyperlink to specific cell across sheet

[KIM Chanthan]

Hi,

Is there any can help if i want to make hyperlink to specific cell across sheet.
There are so many places i need to hyperlink and i will take time without formular.
Please find attached file for more detail.

Thanks,

 

[Chihiro]

Add hyperlink -> Place in This Document.

Or just add helper column in Sheet B using HYPERLINK formula.
IN B4:
=HYPERLINK("#A!A"&MATCH(A4,A!$A$3:$A$6,0)+ROW(A$3)-1,A4)

Copy down.

 

[KIM Chanthan]

Add hyperlink -> Place in This Document.

Or just add helper column in Sheet B using HYPERLINK formula.
IN B4:
=HYPERLINK("#A!A"&MATCH(A4,A!$A$3:$A$6,0)+ROW(A$3)-1,A4)

Copy down.

Thanks Chihiro for your help. It works perfectly as expected