Stephen_IV
Well-known Member
- Joined
- Mar 17, 2003
- Messages
- 1,180
- Office Version
- 365
- 2019
- Platform
- Windows
Can someone please help me. I am looking for some vba to automatically score some answers that I have for questions. The questions are from 1 to 5. I would like VBA to give the the TOTAL score right for each person. Can someone please help me.
Thanks in advance Stephen.
Thanks in advance Stephen.
Book1 | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | Answer1 | Answer2 | Answer3 | Answer4 | Answer5 | Answer6 | Answer7 | TotalScore | ||||
2 | Steve | 2 | 4 | 5 | 2 | 2 | 3 | 2 | 4 | |||
3 | Bob | 3 | 4 | 1 | 2 | 3 | 3 | 2 | 5 | |||
4 | John | 1 | 1 | 1 | 2 | 4 | 3 | 5 | 3 | |||
5 | Mike | 5 | 5 | 4 | 2 | 3 | 1 | 3 | 2 | |||
6 | Ray | 4 | 2 | 4 | 2 | 1 | 5 | 3 | 2 | |||
7 | Tony | 5 | 2 | 1 | 1 | 1 | 2 | 2 | 4 | |||
8 | Sam | 3 | 4 | 2 | 1 | 1 | 5 | 5 | 2 | |||
9 | Tom | 5 | 4 | 5 | 4 | 1 | 2 | 3 | 3 | |||
10 | ||||||||||||
11 | ||||||||||||
12 | ||||||||||||
13 | ||||||||||||
14 | Score | |||||||||||
15 | Answer1 | 5 | ||||||||||
16 | Answer2 | 4 | ||||||||||
17 | Answer3 | 1 | ||||||||||
18 | Answer4 | 2 | ||||||||||
19 | Answer5 | 1 | ||||||||||
20 | Answer6 | 3 | ||||||||||
21 | Answer7 | 2 | ||||||||||
Sheet1 |