Transfer Data From One Sheet to Another

[barim]

Hello,

I need a VBA code that would transfer data from Column D Sheet 1 starting with row 13, which is D13. Destination column is A7 Sheet 2. I tried to find some codes for this but couldn't find anything similar.
Everything is in one workbook.

Any help is appreciated.

Thanks.

 

[Fluff]

How about

Sub barim()
   With Sheets("Sheet1")
      .Range("D13", .Range("D" & Rows.count).End(xlUp)).Copy Sheets("Sheet2").Range("A7")
   End With
End Sub

 

[barim]

Thank you Fluff so much. Simple solution and it works.

 

[Fluff]

Glad to help & thanks for the feedback.