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
Sub IncrmentNumber() Dim ws As Worksheet, LRow As Long, r As Long Set ws = Sheet1 Application.ScreenUpdating = False LastRow = ws.Range("B" & ws.Rows.Count).End(xlUp).Row For r = 2 To LastRow If ws.Cells(r, "C") <> "" Then ws.Cells(r - 1, "A").Value = ws.Cells(r, "A").Value + 1 End If Next Application.ScreenUpdating = True End Sub