Autofill/Other Solution to making cell +8 each time

[liamfrancis2013]

This should be a relatively simple one.

Basically as you can see from the images below i have "h2"; then "h10" then "h18"

1.png2.png
3.png4.png

All i want is to be able to quickly auto fill however when i try to auto fill with the current conditions it doesn't follow the logic of the next cell being "h26"; i'd be open to using some VBA if there is not a simple function for this.

[BadlySpelledBuoy]

Probably not as straightforward as you were hoping, but the formula in B2 on Sheet2 of the attached and copied down produces the desired results.

BSB

[liamfrancis2013]

It was a little more complicated than i thought it would be anyways thanks for the solution brilliant

[BadlySpelledBuoy]

Happy to help.
Thanks for the rep point.

BSB