6 Replies Latest reply: Jun 4, 2013 9:21 AM by Jonathan Brough RSS

    Macro to drill down to another sheet


      I have a simple scorecard, based on a straight table, which shows 3 KPI's records (name, target, realisation, indication). If you want to investigate the details of one of these KPI's you have to click on another sheet and then you get the requested info. I want to replace the clicking on the sheet by clicking on the kpi line in the straight table. Using a button (with functionality "shortcut" and "previous/next" sheet) is a simple way to solve the problem. But, what if i need analyse data which is not stored in next or previous sheet, but f.e. 3 sheets further??? Read some of the topics concerning this problem and according to most members, a macro should do the job. Can anyone help me with creating such macro??