Spreadsheet: 695420d1600196397-need-help-to-loop-a-statement-to-shorten-code-test
Sheet: Table1

Number | Depth | Value
101010405120W300 | 429
101010405120W300 | 429.1
101010405120W300 | 429.2
101010405120W300 | 429.3
101010405120W300 | 429.4
101010405120W300 | 429.5
101010405120W300 | 429.6
101010405120W300 | 429.7
101010405120W300 | 429.8
101010405120W300 | 429.9
101010405120W300 | 430
101010405120W300 | 430.1
101010405120W300 | 430.2
101010405120W300 | 430.3
101010405120W300 | 430.4
101010405120W300 | 430.5
101010405120W300 | 430.6
101010405120W300 | 430.7
101010405120W300 | 430.8
101010405120W300 | 430.9
101010405120W300 | 431
101010405120W300 | 431.1
101010405120W300 | 431.2
101010405120W300 | 431.3
101010405120W300 | 431.4
101010405120W300 | 431.5
101010405120W300 | 431.6
101010405120W300 | 431.7
101010405120W300 | 431.8
101010405120W300 | 431.9
101010405120W300 | 432
101010405120W300 | 432.1
101010405120W300 | 432.2
101010405120W300 | 432.3
101010405120W300 | 432.4
101010405120W300 | 432.5
101010405120W300 | 432.6
101010405120W300 | 432.7
101010405120W300 | 432.8
101010405120W300 | 432.9
101010405120W300 | 433
101010405120W300 | 433.1
101010405120W300 | 433.2
101010405120W300 | 433.3
101010405120W300 | 433.4
101010405120W300 | 433.5
101010405120W300 | 433.6
101010405120W300 | 433.7
101010405120W300 | 433.8
101010405120W300 | 433.9
101010405120W300 | 434
101010405120W300 | 434.1
101010405120W300 | 434.2
101010405120W300 | 434.3
101010405120W300 | 434.4
101010405120W300 | 434.5
101010405120W300 | 434.6
101010405120W300 | 434.7
101010405120W300 | 434.8
101010405120W300 | 434.9
101010405120W300 | 435
101010405120W300 | 435.1
101010405120W300 | 435.2
101010405120W300 | 435.3
101010405120W300 | 435.4
101010405120W300 | 435.5
101010405120W300 | 435.6
101010405120W300 | 435.7
101021105020W300 | 414.0505943309966 |  |  |  | **A2 changes, so need 'value' table to go back to '3'
101021105020W300 | 414.2029868942395
101021105020W300 | 414.3553794574825
101021105020W300 | 414.5077720207254
101021105020W300 | 414.6601645839683
101021105020W300 | 414.8125571472112
101021105020W300 | 414.9649497104541
101021105020W300 | 415.117342273697
101021105020W300 | 415.26973483694
101021105020W300 | 415.4221274001828
101021105020W300 | 415.5745199634258
101021105020W300 | 415.7269125266687
101021105020W300 | 415.8793050899116
101021105020W300 | 416.0316976531545
101021105020W300 | 416.1840902163974
101021105020W300 | 416.3364827796403
101021105020W300 | 416.4888753428833
101021105020W300 | 416.6412679061262
101021105020W300 | 416.7936604693691
101021105020W300 | 416.946053032612
101021105020W300 | 417.0984455958549
101021105020W300 | 417.2508381590978
101021105020W300 | 417.4032307223407
101021105020W300 | 417.5556232855836
101021105020W300 | 417.7080158488266
101021105020W300 | 417.8604084120695
101021105020W300 | 418.0128009753124
101021105020W300 | 418.1651935385553
101021105020W300 | 418.3175861017982
101021105020W300 | 418.4699786650411
101021105020W300 | 418.6223712282841
101021105020W300 | 418.7747637915269
101021105020W300 | 418.9271563547699
101021105020W300 | 419.0795489180128
101021105020W300 | 419.2319414812557
101021105020W300 | 419.3843340444986
101021105020W300 | 419.5367266077415
101021105020W300 | 419.6891191709844
101021105020W300 | 419.8415117342274
101021105020W300 | 419.9939042974702
101021105020W300 | 420.1462968607132
101021105020W300 | 420.2986894239561
101021105020W300 | 420.451081987199