I have a worksheet that I need to be able to select the first active cell to copy and paste in a set range on another worksheet. I then need it to automatically copy then next column of that row cell to another range on the other worksheet. And then repeat one more time for the next column of that row. I tried to record the macro, but it will not do active cell then next column the next column command by recording. I am very very new to VBA and would appreciate any and all help. And any detailed explanations will help me learn more. So thanks in Advance. This is the code the record macro made for me.
Sub Test()
'
' Test Macro
'
Range("G18").Select
Selection.Copy
Windows("Profile Move Worksheet.xlsx").Activate
ActiveSheet.Shapes.Range(Array("TextBox 74")).Select
Windows("WEEKLY MOVES.xlsx").Activate
Range("V18").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Profile Move Worksheet.xlsx").Activate
ActiveSheet.Shapes.Range(Array("TextBox 75")).Select
Windows("WEEKLY MOVES.xlsx").Activate
Range("H18").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Profile Move Worksheet.xlsx").Activate
ActiveSheet.Shapes.Range(Array("TextBox 76")).Select
Windows("WEEKLY MOVES.xlsx").Activate
End Sub