OK, sorry, I missed the point.....

Try it like this:

B2 should be =A1 as you have it now but in C2 use

=B2+1

copy that across......