In Excel sheet,

Cell A5 will be given input value (ie., 1 to 5).

If A5 = 1, then in cell range A8 to A30, it should count cell to the input value [which is 1. ie., A8, A9 etc] and that each cell will run small formula "=SUM(O17:T17)" and blank cells in between it should print "-"

If A5 = 2, then in cell range A8 to A30, it should count cell to the input value [ie, A8, A10(A8+2), A12(A10+2) etc., upto A30]and in these each cell will run small formula "=SUM(O17:T17)" and blank cells in between it should print "-"

If A5 = 3, then in cell range A8 to A30, it should count cell to the input value (ie, A8, A11(A8+3), A14 (A11+3) etc.,upto A30) and in these each cell will run small formula "=SUM(O17:T17)" and blank cells in between it should print "-"

If A5 = 4, then in cell range A8 to A30, it should count cell to the input value (ie, A8, A12(A8+4), A16(A12+4) etc.,upto A30) and in these each cell will run small formula "=SUM(O17:T17)" and blank cells in between it should print "-"

If A5 = 5, then in cell range A8 to A30, it should count cell to the input value (ie, A8, A13(A8+5), A18(A13+5) etc.,upto A30) and in these each cell will run small formula "=SUM(O17:T17)" and blank cells in between it should print "-"

And the input values will range from 1 to 5.

And input cells will be from A5 to A60.

It would be relally appreciate, if any one one could give/wite VB script please.

Thanks.

Kir.