VBA for a calculation where the range is dynamic
Hi,
I have a large data set of student exam results where I am trying to return the result of the calculation =SUM(range)/100, where the range is a dynamic number of exam results (one per row), for each student. As shown in the below example, the range is the Weighted Exam Scores for each student and the result of =SUM(range)/100 should be returned in column 'Weighted Avg.Score' in the first row of each student. Can anyone suggest some VBA code to do this please?
| Student Number |
Exam Credit |
|
Weighted Exam Score |
Weighted Avg. Score |
| 01 |
20 |
11 |
210 |
8.1 |
| 01 |
20 |
10 |
200 |
|
| 01 |
40 |
8 |
320 |
|
| 01 |
20 |
4 |
80 |
|
| 02 |
10 |
14 |
140 |
12.1 |
| 02 |
10 |
15 |
150 |
|
| 02 |
60 |
13 |
780 |
|
| 02 |
20 |
7 |
140 |
|
| 03 |
20 |
7 |
140 |
10.2 |
| 03 |
40 |
13 |
520 |
|
| 03 |
40 |
13 |
520 |
|
| 04 |
10 |
12 |
120 |
11.9 |
| 04 |
10 |
13 |
130 |
|
| 04 |
50 |
13 |
650 |
|
| 04 |
20 |
10 |
200 |
|
| 04 |
10 |
9 |
90 |
|
| 05 |
40 |
12 |
480 |
10.8 |
| 05 |
40 |
10 |
400 |
|
| 05 |
20 |
10 |
200 |
|
|
|
|
|
|
|
|
|
|
|
|
|
