Incrementing Column A Values

  • I have been striving to create a solution that is Increment the Number. Where from Column B data is start that is row 18 so code will copy value from the Column A row 17 to the last row of Column C with incrementing the number.

    I'm hoping you can help me with.


    Result will be like this in Column A

  • If I correctly understood the request, have a try with these modifications:

  • Thank you its working great. royUK Yes it is so simple without VBA but if i use the formula there are approximately 500K rows which will definitely increase the file size using formula which makes it slow.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!