Macros & VBA:

Question

Hello,I have never used macros before. How do I use VBA to move the data from column C to B? I tried recording macros but got stuck with coding (I have never coded).Attached is a picture of my task. Thanks! The data is not real, FYI.&nbsp;

hansvogelaar · Answer

Cr3amcheese&nbsp;
Try this:
Sub MoveData()
    Range("C:C").Cut Destination:=Range("B1")
    Application.CutCopyMode = False
End Sub

cr3amcheese · Answer

Thanks! I found a Chester Tugwell video and it helped me.

Forum Discussion

Macros & VBA:

Share

Resources