View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Joe K.[_2_] Joe K.[_2_] is offline
external usenet poster
 
Posts: 1
Default 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