Inputting a number and have the next number show up 7 cells down

Hello,

When i put a number in a cell I would like the next number to show up exactly 7 cells down. Is there a formula that can help me acheive this? I would be grateful if it didn't include any macros.

I have included an attachment to make it a bit clearer.


Thanks!

I'm not sure if this is exactly what you want to have done or not, but try putting this formula in cell B8 and then copy down:

=IF(B1="","",B1+1)

That's perfect. Thank you very much!