Macros & VBA:

Copper Contributor

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.

vbascreenshot.jpg

 

2 Replies

@Cr3amcheese 

Try this:

Sub MoveData()
    Range("C:C").Cut Destination:=Range("B1")
    Application.CutCopyMode = False
End Sub
Thanks! I found a Chester Tugwell video and it helped me.