Code needed to Copy data from one worksheet to another

[TWINKLEMARVEL]

Dear All,

I have a workbook "Report.xls",in which there are two work sheets "basic" and "final" .

I need to copy and paste the following:

Datas From sheet "basic", Range A5 : A35 to Sheet "final", range A8:A38

Datas From sheet "basic", Range K5 : K35 to Sheet "final", range E8:E38

Datas From sheet "basic", Range B5 : B35 to Sheet "final", range F8:N38

Thanks in advance.

 

[VoG]

Try

Sub test()
With Sheets("basic")
    .Range("A5:A35").Copy Destination:=Sheets("final").Range("A8")
    .Range("K5:K35").Copy Destination:=Sheets("final").Range("E8")
    .Range("B5:B35").Copy Destination:=Sheets("final").Range("F8")
End With
Application.CutCopyMode = False
End Sub

 

[TWINKLEMARVEL]

Thanks a lot VoG. That worked out.