Hyperlink Cell Value to Named Range

[rotiplanta]

Hello and hope you all in peace and healthy.

It is possible macro code for Hyperlink Cell Value to Named Range?.

For example, i have many cell value that can be duplicate in Sheet1. What i trying to do is, Hyperlink them to Named Range.


Sheet1 Cell Value =
A1 = Q.s.1:1 , B1 = Q.s.1:1
A2 = Q.s.1:2 , C1 = Q.s.1:2
A3 = Q.s.1:3 , D1 = Q.s.1:3

Sheet2 Named Range =
A1 = Q.s.1.1
A2 = Q.s.1.2
A3 = Q.s.1.3

I try to Hyperlink Sheet1 Cell A1 and B1 to Named Range Q.s.1.1


Difference between Cell Value and Named Range is , in Cell Value got symbol ":" and in Named Range got symbol "." that i think can help to be a key for Search Function in macro.

Thank You.

[PCI]

Do a selection in Sheet1 and launch the macro
See file attached

Please Login or Register  to view this content.

[rotiplanta]

Thank you very much.

That code work like champ.

Thank you again.

[PCI]

Great, you're welcome.