Is it at all possible to be able to click on a row within a pivot table and link back to the source row, please?
Sample workbook is attached. There are 3 row labels which I will refer to as 'columns'. For each item listed in each column, I would like to click on a cell and link back to the source cell.
- I click on 'Another' (in column A in pivot table), it links me back to cell A191 in 'Sourcedata' w/sheet.
- I click on 'Administrative Support Curriculum' (in column B in pivot table), it links me back to B190 in 'Sourcedata'
- I click on 'Capital Budgeting Roadblock' (in column C in pivot table), it links me back to C184 in 'Sourcedata',