Hello!
I am relatively new to using VBA and am struggling to generate a macro.
What I would like to do is generate a macro to perform a countif function on a column, to see how many individuals selected "1" on a 1-5 rating scale, then do the same countif function for ratings 2-5.
I will need to perform this calculation on multiple (possibly hundreds of columns).
Is there a fairly simple process to have the Countif macro generate the total 5 countif scores, evaluating each column individually?
Thanks!
I am relatively new to using VBA and am struggling to generate a macro.
What I would like to do is generate a macro to perform a countif function on a column, to see how many individuals selected "1" on a 1-5 rating scale, then do the same countif function for ratings 2-5.
I will need to perform this calculation on multiple (possibly hundreds of columns).
Is there a fairly simple process to have the Countif macro generate the total 5 countif scores, evaluating each column individually?
Thanks!
