EXCEL - HOW TO MOVE MULTIPLE DATA (ONLY) FROM COLUMN TO OTHER COLUMN BLANK

RanzieJ 

Hi there.

Filter the credit account and choose the range like this:

Then fill them left like that:

RanzieJ You need VBA coding to cut/move data. Give a try on below sub. Assuming you Credit Account column is B. You have to adjust Range("B2:B200") for you real case.

Sub MoveData()
Dim rng As Range

    For Each rng In Range("B2:B200")
        If rng <> "" Then
            rng.Offset(, -1) = rng
            rng.Clear
        End If
    Next rng

End Sub