Excel VBA - Create hyperlink to different sheet when the cell value is same

  • Hi team,


    I would like your help to create macro to create hyperlink between worksheets.


    I tried below, however it is not working.


    Would anyone please help?


    I tried Vloopup and Hyperlink but it does not work as well (=HYPERLINK(VLOOKUP(A7,Instructions!A:A,1,FALSE),"LINK"))





    Thank you!

    Files

    • Book1.xlsm

      (17.77 kB, downloaded 86 times, last: )
  • Hello,


    Attached is your Test file ...


    Hope it is in line with your expectations

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • I just lost my word. This is PERFECT!! Thank you so much Carim! Like Like Like!


    Thanks a LOT for your very kind words .... AND for the Like Like Like  :):):)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)