Tallying Survery Results

Your attachment seems to have failed to attach.

How much of this is specifically about Excel, and how much of your question is a more statistically generic "how do I analyze rating scale data"? I know these kind of rating scales are common in statistical analysis, and I'm sure there are many standard methods for "tallying" and analyzing these surveys, but I am not familiar with them. If you understand the statistical method you want to use and can explain it to us, we will be better able to help you program that into the spreadsheet.

I would expect that some of the first steps in tallying or analyzing these results will be some simple =COUNT(), SUM(), SUMIF(), COUNTIF(), or similar functions. I personally would perform these calculations using the spreadsheet functions rather than VBA, though I think it really depends on whether you are more comfortable with the "spreadsheet formula" programming language or the "VBA" programming language. For example, if the respondent was instructed to use "X"s to mark the result, and my "tally" included counting the number of X's in the "no value" column, I might put =COUNTA(B4:B44) at the bottom of column B to count the number of non-blank entries in the "no value" column.