I'm trying to develop a convenient solution for preparation of a summary sheet comprising of lots of grading sheet underneath it.
I have a tabular excel sheet used for obtaining feedback from random users. It contains 20 questions, against which there are four columns: Excellent, Good, Fair, N/a.
In my workbook I currently have 28 feedback sheets. I need to prepare a summary sheet in the exact same formatting. This summary sheet will show percentages of the feedback received. For example: For question 1, 60% excellent, 30% good, 10% fair, and then for all twenty questions.
This I'm doing by manually selecting the cells in all the sheets and dividing them by the number of sheets to get the percentage, and then dragging the formula down.
What I am missing is that sometimes I need to view percentages of some selected feedbacks. For that I am currently changing formulas everytime I need to change the view.
I was thinking is there some way I could develop a Selection sheet, in which all my feedback sheets are listed. I put some tick mark in front of the feedback sheets and only those sheets are taken by the formula. Something like the pivot table, but spread over various sheets.
Any guidelines would be appreciated.
UPDATE: Sample file: Sample file