2 Replies Latest reply on Nov 15, 2016 4:23 AM by Ravindra Zinjad

    Using column value as hyperlink


      Hi All,

      I am having workbook which contains worksheets. Basically what I want do is I have column when I should click on the value it should redirect me to a new worksheet. With values related to that field. For Example

           X Y Z

      A  1  2 3

      B  4  5 6

      C  7  8  9



      So If I Click on 1 it should take me to a different sheet and it should have values of other fields related to 1. For example

      X M   N    O   P

      1 23  22  20  15


      I created an action but it did not worked the way I wanted. I am unable to achieve this. Any help would be appreciated. Thanks in advance.