Posts by GShank

GShank · Jun 18th 2016

Re: Loop through column and update

Can you send the sample excel file to my mail id, so that i can check and revert?

GShank · Jun 18th 2016

Re: Insert row where sequential value is missing, including first and last values.

Try this code on the original excel..

Code

Sub Reply()
    i = 1
    Do While Cells(i, 2) <> ""
        j = Cells(i + 1, 2).Value - Cells(i, 2).Value - 1
        If j < 0 Then j = 8 - Cells(i, 2).Value + Cells(i + 1, 2).Value
        For k = 1 To j
            Rows(i + k).EntireRow.Insert
        Next k
        i = i + k
    Loop
End Sub

Display More