i need a ms excel formula which automatically do like this
it should copy the value in
`B1` and should paste it from `A1` to `A7` and then copy the value in
`B8` and should paste it from `A8` to `A14` and then copy the value in
`B15`and should paste it from `A15` to `A21` and so on...
hope you understand, if not please let me know. i will try to expand my question thank you!

waiting for your answer.

(my excel version : 2007)