Excel Reporting Funtions

Bare with me as this question has a couple of elements to it...

I have a training matrix with Company Organisational Chart in first few columns e.g. Unit Departments and Position Titles in first two columns on left of worksheet(approx 1100 positions in Company), and along Row 2 at top of worksheet, in separate columns, are Training module names e.g. "Induction Training", "Fire Awareness Training.

Where a position requires training, an "x" is placed at the intersecting point (e.g. Row 11, Column BA). I would like excel to report the names of all modules required for a position (row) if selected on a dashboard report.

I've set up a pivot table and some slicers for my dashboard and can get the Unit/Position Title/Total number of Training Modules to link, but cannot get excel to report the names of the Training Modules for the role I select on the dashboard. (clear as mud?) Does anyone know if what i'm trying to achieve is at all possible? I really need to get this sorted if anyone can help??? Do you need more info? I appreciate anyone's assistance.

Recent Questions...