View Single Post
 
Old 03-31-2018, 04:38 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default

try this
Code:
Sub Move_Info()

    Dim lr As Long, i As Long
    Dim ray As Variant

Application.ScreenUpdating = False

With ActiveSheet
    lr = .Cells(Rows.Count, "A").End(xlUp).Row
    For i = 3 To lr Step 2
        Set ray = Nothing
        ray = Split(.Cells(i, "A").Value, " ")
        .Cells(i - 1, "B").Value = ray(0)
        .Cells(i - 1, "C").Value = ray(1)
        .Cells(i, "A").ClearContents
    Next i
End With

Application.ScreenUpdating = True

End Sub
Reply With Quote