that sounds great Adak, I continually need to thank you for the amount of time, patience, and gratitude you're giving me, so thanks again.
for ease of changing the data, such as the test1, test2, test3, should i change this;
Code:
100 Jeff 98,76,86 8 41
101 Mark 66,51,76 4 31
102 Jenn 79,89,93 9 44
103 Chris 44,78,45 3 28
104 Matt 74,81,88 8 39
105 Dan 67,91,83 6 24
106 Dave 55,81,75 7 45
107 Rich 91,93,89 9 32
108 Mike 55,61,78 3 26
109 Tony 67,68,78 5 45
110 Rob 89,71,80 7 42
111 Sonny 78,81,89 8 15
112 Luke 91,83,75 8 24
113 April 66,79,70 6 35
114 Sheryl 89,81,85 9 50
115 Tom 79,61,90 5 33
116 Lamont 80,76,89 7 41
117 Steve 90,98,100 10 50
118 Jake 90,78,69 8 25
219 Austin 91,45,88 7 29
0 0,0,0 0 0
to something like this;
Code:
100 Jeff 98 76 86 8 41
101 Mark 66 51 76 4 31
102 Jenn 79 89 93 9 44
103 Chris 44 78 45 3 28
104 Matt 74 81 88 8 39
105 Dan 67 91 83 6 24
106 Dave 55 81 75 7 45
107 Rich 91 93 89 9 32
108 Mike 55 61 78 3 26
109 Tony 67 68 78 5 45
110 Rob 89 71 80 7 42
111 Sonny 78 81 89 8 15
112 Luke 91 83 75 8 24
113 April 66 79 70 6 35
114 Sheryl 89 81 85 9 50
115 Tom 79 61 90 5 33
116 Lamont 80 76 89 7 41
117 Steve 90 98 100 10 50
118 Jake 90 78 69 8 25
219 Austin 91 45 88 7 29
0 0 0 0 0 0