Please see attach spreadsheet for example,
Can you please help me automate the counting of records using a macro.
There are three worksheets
1. Priorities - Lists all the Priorities in column A that will be used in responses on the Responses worksheet
2. Responses - Each row is a set of responses by a user and there may be up to 50 user responses. I will populate these manually. The worksheet has some examples. The responses going across the row can go up to 150 after the name in column b.
3. Results - Counts the responses for every row by user that is in the responses worksheet. The responses are are totaled in the last column. (or on a separate worksheet if easier)
When you look at the attached file you can see two examples.