Extracting data from table using VBA looping

Column A:E is the data I am using in an attempt to create a table with VBA.

Column G should be $A$1 and Column H should be $A$2. Column J should correspond to the data as presented in the picture.

I was able to loop my duration to 100 which I wanted, but that is about as far as I have gotten.

I was able to loop PlanName and IssueAge but I hardcoded the data, which I don't really want to do because the issue age will change after the duration 100, and will begin again at 1 again for the new issue age.

Factor for duration 1-5 should be row A3:E3, factor for duration 6-10 should be row A4:E4, so on and so forth.

Eventually there will be a new issue age of 11 (all the way to 65), and new duration (for each new issue age). I would like to create a VBA to loop so I won't have to do much inputting, but this is my first attempt at VBA and I'm stuck.

Reserve Snippet 2.PNG

Sub TerminalReserve()
Dim TermReserve As Range
Dim DurationAddress As String
Dim PlanName As String
Dim IssueAge As String
Dim Duration As String
Dim Factor As String
Dim x As Integer
Dim PlanNameAddress As String
Dim rowdum As Variant
Dim counter As Integer
Dim ReserveName As String
Dim IssueNameAddress As String
Dim IssuingAge As String

'HardCoding of PlanName and Issue Age
ReserveName = "20000001"
IssuingAge = "10"


'Creating Table Header
PlanName = "PlanName"
Range("G1").Value = PlanName

IssueAge = "IssueAge"
Range("H1").Value = IssueAge

Duration = "Duration"
Range("I1").Value = Duration

Factor = "Factor"
Range("J1").Value = Factor

'Creating Duration, IssueAge, & PlanName Inputs
x = 1
While x < 101
PlanNameAddress = "G" + VBA.Trim(Str(x + 1))
IssueNameAddress = "H" + VBA.Trim(Str(x + 1))
DurationAddress = "I" + VBA.Trim(Str(x + 1))
Range(DurationAddress).Value = x
x = x + 1
Range(PlanNameAddress).Value = ReserveName
Range(IssueNameAddress).Value = IssuingAge
Wend


'Selects TermReserve
Set TermReserve = Range("A1:E869")
TermReserve.Select

'Inputs for Factor Table

For Each rw In Range("TermReserve").Rows



Loop While counter < 5






End Sub








This is the coding I have so far, but what I am ultimately having trouble with is getting a code right to take data from a row and put it in a column in an orderly fashion.

Please place your code with [ CODE ] Tags.

Please Login or Register  to view this content.

20000001 10 115
10 10 100
0.34 0.53 0.72 0.9 1.05
1.15 1.13 0.98 0.77 0.53
0.28 0.24 0.24 0.24 0.24
0.24 0.24 0.24 0.24 0.24
0.24 0.24 0.24 0.24 0.24
0.24 0.24 0.24 0.33 0.44
0.55 0.67 0.78 0.9 1.01
1.12 1.23 1.33 1.43 1.53
1.64 1.74 1.84 1.95 2.04
2.13 2.21 2.28 2.33 2.35
2.36 2.34 2.28 2.19 2.05
1.87 1.62 1.32 0.94 0.49
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
11 11 100
0.34 0.54 0.71 0.86 0.96
0.94 0.8 0.59 0.35 0.25
0.25 0.25 0.25 0.25 0.25
0.25 0.25 0.25 0.25 0.25
0.25 0.25 0.25 0.25 0.25
0.25 0.25 0.25 0.29 0.4
0.52 0.64 0.76 0.88 0.99
1.1 1.2 1.31 1.41 1.52
1.63 1.73 1.84 1.94 2.04
2.12 2.19 2.24 2.28 2.29
2.27 2.22 2.14 2.01 1.83
1.6 1.3 0.93 0.49 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
12 12 100
0.35 0.52 0.67 0.77 0.76
0.61 0.4 0.25 0.25 0.25
0.25 0.25 0.25 0.25 0.25
0.25 0.25 0.25 0.25 0.25
0.25 0.25 0.25 0.25 0.25
0.25 0.25 0.25 0.26 0.38
0.5 0.62 0.74 0.85 0.97
1.07 1.18 1.29 1.4 1.51
1.62 1.73 1.84 1.94 2.03
2.1 2.16 2.2 2.22 2.21
2.17 2.09 1.97 1.8 1.57
1.28 0.92 0.49 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
13 13 95
0.34 0.49 0.59 0.57 0.43
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.36
0.48 0.6 0.72 0.84 0.95
1.06 1.17 1.29 1.4 1.52
1.63 1.74 1.85 1.94 2.02
2.08 2.13 2.15 2.15 2.11
2.04 1.93 1.76 1.54 1.26
0.91 0.49 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
14 14 95
0.33 0.43 0.41 0.27 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.36
0.48 0.6 0.72 0.84 0.95
1.07 1.18 1.3 1.42 1.54
1.65 1.76 1.86 1.94 2.01
2.06 2.09 2.09 2.06 2
1.89 1.73 1.52 1.25 0.91
0.49 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
15 15 95
0.3 0.28 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.39
0.51 0.63 0.75 0.86 0.98
1.1 1.22 1.34 1.46 1.58
1.69 1.8 1.88 1.95 2.01
2.04 2.05 2.02 1.96 1.86
1.7 1.5 1.23 0.9 0.49
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
16 16 95
0.27 0.27 0.27 0.27 0.27
0.27 0.27 0.27 0.27 0.27
0.27 0.27 0.27 0.27 0.27
0.27 0.27 0.27 0.27 0.27
0.27 0.27 0.27 0.27 0.27
0.27 0.27 0.27 0.34 0.46
0.59 0.7 0.82 0.94 1.06
1.18 1.31 1.43 1.55 1.66
1.76 1.85 1.93 1.98 2.01
2.02 2 1.94 1.84 1.69
1.49 1.23 0.9 0.49 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
17 17 95
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.28 0.41 0.53 0.65
0.77 0.88 1 1.12 1.24
1.36 1.48 1.6 1.71 1.81
1.9 1.97 2.02 2.05 2.06
2.03 1.97 1.86 1.71 1.5
1.24 0.9 0.49 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
18 18 90
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.26
0.26 0.26 0.26 0.26 0.3
0.42 0.55 0.67 0.78 0.9
1.01 1.12 1.24 1.35 1.47
1.59 1.7 1.81 1.9 1.98
2.05 2.09 2.12 2.12 2.09
2.02 1.91 1.75 1.53 1.25
0.91 0.49 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
19 19 90
0.25 0.25 0.25 0.25 0.25
0.25 0.25 0.25 0.25 0.25
0.25 0.25 0.25 0.25 0.25
0.25 0.25 0.25 0.25 0.25
0.25 0.25 0.35 0.47 0.59
0.71 0.83 0.94 1.05 1.16
1.27 1.38 1.49 1.6 1.71
1.82 1.92 2.01 2.09 2.15
2.19 2.2 2.2 2.16 2.08
1.96 1.79 1.56 1.28 0.92
0.49 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
20 20 90
0.25 0.25 0.25 0.25 0.25
0.25 0.25 0.25 0.25 0.25
0.25 0.25 0.25 0.25 0.25
0.25 0.25 0.25 0.25 0.31
0.42 0.54 0.66 0.78 0.89
1.01 1.12 1.22 1.32 1.43
1.53 1.64 1.75 1.85 1.96
2.05 2.13 2.2 2.25 2.29
2.3 2.28 2.23 2.15 2.02
1.84 1.6 1.3 0.93 0.49
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
21 21 90
0.24 0.24 0.24 0.24 0.24
0.24 0.24 0.24 0.24 0.24
0.24 0.24 0.24 0.24 0.24
0.24 0.3 0.41 0.51 0.62
0.74 0.85 0.97 1.08 1.19
1.29 1.39 1.49 1.59 1.69
1.79 1.9 2 2.09 2.18
2.26 2.32 2.36 2.39 2.39
2.37 2.31 2.21 2.07 1.88
1.64 1.33 0.95 0.49 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
22 22 90
0.23 0.23 0.23 0.23 0.23
0.23 0.23 0.23 0.23 0.23
0.23 0.23 0.23 0.31 0.4
0.5 0.6 0.71 0.82 0.93
1.04 1.15 1.26 1.36 1.46
1.56 1.65 1.75 1.84 1.94
2.04 2.13 2.22 2.3 2.37
2.43 2.47 2.49 2.48 2.45
2.38 2.28 2.13 1.93 1.67
1.35 0.96 0.49 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
23 23 85
0.23 0.23 0.23 0.23 0.23
0.23 0.23 0.23 0.23 0.24
0.31 0.4 0.49 0.58 0.67
0.77 0.87 0.98 1.09 1.2
1.3 1.41 1.51 1.61 1.7
1.79 1.88 1.97 2.07 2.16
2.25 2.33 2.41 2.48 2.53
2.56 2.57 2.56 2.52 2.45
2.34 2.18 1.97 1.7 1.37
0.97 0.49 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
24 24 85
0.22 0.22 0.22 0.22 0.22
0.22 0.24 0.3 0.37 0.45
0.53 0.62 0.71 0.8 0.9
1 1.1 1.21 1.32 1.42
1.52 1.62 1.72 1.81 1.9
1.98 2.07 2.16 2.25 2.34
2.42 2.49 2.55 2.6 2.63
2.63 2.62 2.57 2.49 2.38
2.21 2 1.73 1.39 0.98
0.49 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
25 25 85
0.22 0.22 0.22 0.22 0.27
0.32 0.39 0.46 0.53 0.62
0.7 0.79 0.88 0.98 1.08
1.18 1.28 1.39 1.49 1.59
1.69 1.79 1.87 1.96 2.05
2.13 2.22 2.31 2.39 2.47
2.54 2.6 2.64 2.67 2.67
2.65 2.6 2.52 2.4 2.24
2.02 1.74 1.4 0.98 0.49
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
26 26 85
0.22 0.23 0.26 0.31 0.36
0.43 0.5 0.57 0.65 0.74
0.83 0.92 1.01 1.11 1.21
1.32 1.42 1.53 1.63 1.72
1.82 1.9 1.99 2.07 2.16
2.25 2.33 2.42 2.49 2.56
2.62 2.66 2.69 2.69 2.67
2.62 2.54 2.42 2.25 2.03
1.75 1.4 0.99 0.49 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
27 27 85
0.23 0.26 0.31 0.36 0.43
0.5 0.57 0.65 0.74 0.83
0.92 1.02 1.11 1.22 1.32
1.42 1.53 1.63 1.72 1.82
1.9 1.99 2.07 2.16 2.25
2.33 2.42 2.49 2.56 2.62
2.66 2.69 2.69 2.67 2.62
2.54 2.42 2.25 2.03 1.75
1.4 0.99 0.49 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
28 28 80
0.24 0.28 0.34 0.4 0.48
0.55 0.63 0.72 0.81 0.9
1 1.09 1.2 1.3 1.4
1.51 1.61 1.71 1.8 1.89
1.97 2.06 2.14 2.23 2.32
2.4 2.48 2.55 2.61 2.65
2.68 2.68 2.66 2.61 2.53
2.41 2.24 2.02 1.74 1.4
0.99 0.49 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
29 29 80
0.25 0.3 0.37 0.44 0.51
0.6 0.68 0.77 0.86 0.96
1.06 1.16 1.27 1.37 1.48
1.58 1.68 1.77 1.86 1.95
2.03 2.12 2.21 2.29 2.38
2.46 2.53 2.59 2.63 2.66
2.66 2.64 2.6 2.52 2.4
2.23 2.01 1.74 1.4 0.98
0.49 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
30 30 80
0.25 0.32 0.39 0.47 0.55
0.63 0.73 0.82 0.92 1.01
1.12 1.22 1.33 1.43 1.54
1.64 1.73 1.82 1.91 2
2.08 2.17 2.26 2.35 2.43
2.5 2.56 2.61 2.63 2.64
2.62 2.58 2.5 2.38 2.22
2 1.73 1.39 0.98 0.49
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
31 31 80
0.26 0.33 0.41 0.49 0.58
0.67 0.76 0.86 0.96 1.07
1.17 1.28 1.38 1.49 1.59
1.68 1.77 1.86 1.95 2.04
2.13 2.22 2.31 2.39 2.47
2.53 2.58 2.61 2.61 2.6
2.56 2.48 2.36 2.2 1.99
1.72 1.38 0.98 0.49 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
32 32 80
0.26 0.34 0.43 0.51 0.61
0.7 0.8 0.9 1.01 1.11
1.22 1.33 1.43 1.53 1.63
1.72 1.81 1.9 1.99 2.09
2.18 2.27 2.35 2.43 2.49
2.54 2.57 2.58 2.57 2.53
2.46 2.34 2.19 1.97 1.71
1.38 0.97 0.49 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
33 33 75
0.27 0.35 0.44 0.53 0.63
0.73 0.83 0.94 1.05 1.16
1.27 1.37 1.47 1.57 1.67
1.76 1.85 1.94 2.03 2.13
2.22 2.31 2.38 2.45 2.5
2.54 2.55 2.54 2.5 2.43
2.32 2.17 1.96 1.69 1.37
0.97 0.49 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
34 34 75
0.27 0.36 0.46 0.55 0.66
0.76 0.87 0.98 1.09 1.2
1.3 1.41 1.51 1.6 1.7
1.79 1.88 1.98 2.07 2.17
2.26 2.34 2.41 2.46 2.5
2.51 2.5 2.47 2.4 2.3
2.14 1.94 1.68 1.36 0.96
0.49 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
35 35 75
0.28 0.37 0.47 0.57 0.68
0.79 0.9 1.01 1.12 1.23
1.34 1.44 1.53 1.63 1.73
1.82 1.92 2.02 2.11 2.2
2.29 2.36 2.41 2.45 2.47
2.47 2.44 2.37 2.27 2.12
1.92 1.67 1.35 0.96 0.49
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
36 36 75
0.28 0.38 0.49 0.59 0.7
0.82 0.93 1.04 1.15 1.26
1.36 1.46 1.56 1.66 1.75
1.85 1.95 2.05 2.15 2.23
2.31 2.37 2.41 2.43 2.43
2.4 2.34 2.24 2.1 1.9
1.65 1.34 0.95 0.49 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
37 37 75
0.29 0.39 0.5 0.61 0.73
0.84 0.96 1.07 1.18 1.28
1.38 1.48 1.58 1.68 1.79
1.89 1.99 2.08 2.17 2.25
2.31 2.36 2.38 2.39 2.36
2.31 2.21 2.07 1.88 1.63
1.33 0.95 0.49 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
38 38 70
0.3 0.4 0.52 0.63 0.75
0.87 0.98 1.09 1.2 1.3
1.4 1.5 1.61 1.71 1.82
1.92 2.02 2.11 2.19 2.26
2.31 2.33 2.34 2.32 2.27
2.18 2.04 1.86 1.62 1.31
0.94 0.49 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
39 39 70
0.3 0.42 0.53 0.65 0.77
0.89 1 1.11 1.21 1.32
1.42 1.53 1.63 1.74 1.85
1.95 2.04 2.13 2.2 2.25
2.28 2.29 2.28 2.23 2.14
2.01 1.83 1.6 1.3 0.93
0.49 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
40 40 70
0.31 0.43 0.55 0.67 0.79
0.9 1.01 1.12 1.23 1.33
1.44 1.55 1.66 1.77 1.88
1.97 2.06 2.13 2.19 2.23
2.24 2.23 2.19 2.11 1.98
1.81 1.58 1.29 0.93 0.49
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
41 41 70
0.31 0.44 0.56 0.68 0.8
0.91 1.02 1.13 1.24 1.35
1.46 1.58 1.69 1.8 1.9
1.99 2.07 2.13 2.17 2.19
2.18 2.14 2.07 1.95 1.78
1.56 1.27 0.92 0.49 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
42 42 70
0.32 0.44 0.57 0.69 0.8
0.92 1.03 1.14 1.25 1.37
1.49 1.6 1.72 1.82 1.92
2 2.06 2.11 2.13 2.13
2.1 2.03 1.91 1.75 1.53
1.26 0.91 0.49 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
43 43 65
0.32 0.45 0.57 0.69 0.81
0.92 1.04 1.15 1.27 1.39
1.51 1.63 1.74 1.84 1.92
1.99 2.04 2.07 2.07 2.05
1.98 1.88 1.72 1.51 1.24
0.9 0.49 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
44 44 65
0.33 0.45 0.58 0.69 0.81
0.93 1.05 1.17 1.3 1.42
1.54 1.65 1.76 1.85 1.92
1.98 2.01 2.02 2 1.94
1.84 1.69 1.49 1.22 0.89
0.49 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
45 45 65
0.33 0.46 0.58 0.7 0.82
0.95 1.07 1.2 1.33 1.45
1.57 1.67 1.77 1.85 1.91
1.95 1.96 1.95 1.89 1.8
1.66 1.46 1.21 0.89 0.49
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
46 46 65
0.34 0.46 0.59 0.71 0.84
0.97 1.1 1.23 1.36 1.48
1.59 1.69 1.77 1.84 1.88
1.9 1.89 1.85 1.76 1.63
1.44 1.19 0.88 0.49 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
47 47 65
0.34 0.47 0.6 0.73 0.86
1 1.13 1.26 1.39 1.51
1.61 1.7 1.77 1.82 1.84
1.84 1.8 1.72 1.59 1.41
1.17 0.87 0.49 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
48 48 60
0.35 0.48 0.62 0.75 0.89
1.03 1.17 1.3 1.42 1.53
1.62 1.69 1.75 1.78 1.79
1.75 1.68 1.56 1.38 1.15
0.86 0.49 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
49 49 60
0.36 0.5 0.64 0.78 0.92
1.06 1.2 1.32 1.44 1.54
1.62 1.68 1.72 1.73 1.7
1.63 1.52 1.36 1.13 0.85
0.49 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
50 50 60
0.37 0.51 0.66 0.81 0.95
1.09 1.22 1.34 1.45 1.54
1.6 1.65 1.66 1.65 1.59
1.48 1.33 1.11 0.84 0.49
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
51 51 60
0.38 0.53 0.68 0.83 0.98
1.11 1.24 1.35 1.44 1.52
1.57 1.6 1.59 1.54 1.44
1.29 1.09 0.83 0.49 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
52 52 60
0.39 0.55 0.7 0.85 1
1.13 1.25 1.35 1.43 1.49
1.52 1.52 1.48 1.39 1.26
1.07 0.81 0.49 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
53 53 55
0.4 0.56 0.72 0.87 1.01
1.13 1.24 1.33 1.4 1.44
1.45 1.42 1.34 1.22 1.04
0.8 0.49 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
54 54 55
0.41 0.57 0.73 0.87 1.01
1.13 1.23 1.3 1.36 1.37
1.35 1.29 1.18 1.01 0.78
0.49 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
55 55 55
0.42 0.58 0.73 0.88 1
1.11 1.2 1.26 1.29 1.28
1.23 1.13 0.98 0.77 0.49
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
56 56 55
0.42 0.59 0.74 0.87 0.99
1.09 1.17 1.21 1.21 1.17
1.09 0.95 0.75 0.49 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
57 57 55
0.43 0.59 0.74 0.87 0.98
1.06 1.12 1.13 1.11 1.04
0.92 0.74 0.49 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
58 58 50
0.44 0.6 0.74 0.86 0.96
1.02 1.05 1.04 0.99 0.88
0.72 0.49 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
59 59 50
0.45 0.6 0.73 0.84 0.92
0.97 0.97 0.93 0.84 0.7
0.49 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
60 60 50
0.46 0.6 0.73 0.82 0.88
0.9 0.88 0.8 0.68 0.49
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
61 61 50
0.46 0.6 0.71 0.79 0.82
0.82 0.76 0.66 0.49 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
62 62 50
0.47 0.6 0.69 0.74 0.75
0.72 0.63 0.49 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
63 63 45
0.48 0.58 0.66 0.69 0.67
0.61 0.49 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
64 64 45
0.48 0.57 0.62 0.63 0.59
0.49 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
65 65 45
0.48 0.55 0.58 0.56 0.49
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0
0 0 0 0 0



Data of what I am trying to do all this from.

Duplicate thread. Please do not reply to this thread. See http://www.excelforum.com/excel-prog...y-looping.html