break points using formula

[sandeephg]

Hi All,

Could some help me on putting break point on every 7th line in attached sheet?

I do have larger data to work on hence I am looking for any formula which gives result as “B” in Column B on every 7th after by after.
Any feed back is welcome

Thanks in advance

Sandy -;@