Sub Sample_XlsDwl()
Range("B5").Formula = "=INDEX(B!$B$8:$AAK$1187,$B$2,1)"
Range("B7").Formula = "=INDEX(B!$B$8:$AAK$1187,$B$2,2)"
Range("B9").Formula = "=INDEX(B!$B$8:$AAK$1187,$B$2,3)"
Range("B11").Formula = "=INDEX(B!$B$8:$AAK$1187,$B$2,4)"
Range("D14").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5)"
Range("D15").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 4)"
Range("D16").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 8)"
Range("D17").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 12)"
Range("D18").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 16)"
Range("D19").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 20)"
Range("D20").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 24)"
Range("D21").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 28)"
Range("D22").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 32)"
Range("D23").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 36)"
Range("D24").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 40)"
Range("D25").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 44)"
Range("D26").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 48)"
Range("D27").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 52)"
Range("D28").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 56)"
Range("D29").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 60)"
Range("D30").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 64)"
Range("D31").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 68)"
Range("D32").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 72)"
Range("D33").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 76)"
Range("D34").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 80)"
Range("D35").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 84)"
Range("D36").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 88)"
Range("D37").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 92)"
Range("D38").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 96)"
Range("D39").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 100)"
Range("D40").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 104)"
Range("D41").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 108)"
Range("D42").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 112)"
Range("D43").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 116)"
Range("D44").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 120)"
Range("D45").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 124)"
Range("D46").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 128)"
Range("D47").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 132)"
Range("D48").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 136)"
Range("D49").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 140)"
Range("D50").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 144)"
Range("D51").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 148)"
Range("D52").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 152)"
Range("D53").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,5 + 156)"
Range("E14").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6)"
Range("E15").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 4)"
Range("E16").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 8)"
Range("E17").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 12)"
Range("E18").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 16)"
Range("E19").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 20)"
Range("E20").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 24)"
Range("E21").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 28)"
Range("E22").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 32)"
Range("E23").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 36)"
Range("E24").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 40)"
Range("E25").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 44)"
Range("E26").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 48)"
Range("E27").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 52)"
Range("E28").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 56)"
Range("E29").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 60)"
Range("E30").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 64)"
Range("E31").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 68)"
Range("E32").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 72)"
Range("E33").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 76)"
Range("E34").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 80)"
Range("E35").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 84)"
Range("E36").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 88)"
Range("E37").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 92)"
Range("E38").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 96)"
Range("E39").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 100)"
Range("E40").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 104)"
Range("E41").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 108)"
Range("E42").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 112)"
Range("E43").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 116)"
Range("E44").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 120)"
Range("E45").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 124)"
Range("E46").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 128)"
Range("E47").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 132)"
Range("E48").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 136)"
Range("E49").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 140)"
Range("E50").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 144)"
Range("E51").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 148)"
Range("E52").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 152)"
Range("E53").Formula = "=INDEX(B!$B$8:$AAK$1185,$B$2,6 + 156)"