VBC code to copy and paste data from one sheet to another

[vnoreau]

Hello, I am not sure if I will explain this well but let's try. What I need is a vba code to copy and paste data from one sheet to another. Each time the macro would be run, the amount of data would change. (Meaning the amount of rows will vary each time). The data would be contained between columns A and M on sheet named DATA, and the total rows vary. I need it pasted into sheet named Template in rows C to N, starting at row 7.Thank you for your help.

 

[kevin lazell]

hi vnoreau
try the following ( not the best bit of code you will see but it works

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
x = Range("a" & Rows.Count).End(xlUp).Row
y = 1
Range("a" & y & ":m" & x).Copy
y = 7: x = x + 7
Sheets("template").Range("a" & y & ":m" & x).PasteSpecial xlPasteValues
Application.CutCopyMode = False
End Sub

cheers

kevin