I have data results (20 questions) on 50 different spreadsheets. I want to
consolidate the result of the 20 questions into a meaningful report, within
Excel. Is there a good way to find out, for example, how many of the 50
respondents rated question number 1 as a 1, 2, 3, 4, or 5? My final result is
to find out something like:

Question 1:

1: Strongly Agree (10 responses)
2: Agree (20 responses)
3: Neutral (10 responses)
4: Disagree (10 responses)
5: Strongly Disagree (0 responses)

....and so on throughout the 20 questions. The surveys are all identical and
in an Excel form, so each cell on each survey is the same (with the exception
of the response that the associate has marked). I'm comfortable with most
macros, so if that's the way to go I'm open!
--
Thank you! - Jennifer