3 Replies Latest reply on Jan 3, 2018 12:39 PM by Joe Oppelt

    how to create action to link to different workbook based on criteria

    Rau Cu

      I have a workbook

      Name
      Type1
      Type2
      Type3
      Charlotte2329
      Greenville54545
      concord543432
      shrewsbury2322

       

      this is my summary workbook and i have three different detail workbook. i need to be able to drill down from summary to detail when they click on

      type1(charlotte) value 2 it goes to type1detail workbook

      type2(charlotte) value 3 it goes to type2detail workbook

      type3(charlotte) value 29 it goes to type3detail workbook

       

       

      how do i achieve this drill down using actions. Any advice is appreciated