Jun 21 2024 12:29 PM - edited Jun 21 2024 12:30 PM
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.
Jun 21 2024 12:36 PM
Try this:
Sub MoveData()
Range("C:C").Cut Destination:=Range("B1")
Application.CutCopyMode = False
End Sub