Copy Rows From Worksheet Into Another Worksheet Same Workbook
Please help me modify the movesheet macro listed below to start on row 10 on
the
source worksheet (Sheet1) and destination worksheet (Test) to start on row 3.
Thanks so much for your help.
Sub movesheet()
With Sheets("Sheet1")
..Columns("B:B").Copy _
Destination:=Sheets("Test").Columns("C:C")
..Columns("C:C").Copy _
Destination:=Sheets("Test").Columns("G:G")
..Columns("F:F").Copy _
Destination:=Sheets("Test").Columns("F:F")
End With
End Sub
|