Paste rows to a new worksheet in the next available row

I am new at this but want to use a macro to paste a row to the next available row on another worksheet. I do not understand code but was wondering if this could be done when recording a macro. Any help would be apreciated. I am working in excel 2007

If you record the macro, the next time you run it, it will paste the data in the exact same row as the previous run. You can do this through VBA coding.
for e.g.

Please Login or Register  to view this content.

This will copy row 2 (from A to G) from Sheet1 into sheet 2 in the next available row.

Below is the macro as I have it. Could you show me what needs to be changed to make it paste to the next available row in the DATA worksheet. Everything works fine up until it pastes to the next available row in the DATA worksheet.

Sheets("Report").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
Sheets("COLLECTION").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("DATA").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False

Your code seems incomplete in places. For example. It says -

Please Login or Register  to view this content.

but its not showing what it is copying.
Also, you do not need to use .select in codes. You can directly copy like how i gave the example above.

One more thing, the code example i gave in post 2 will not work for paste special. In that case, you can alter the example as

Please Login or Register  to view this content.

Since you would like to continue with your style of coding, you just need to add a line at the end (before End Sub)

Please Login or Register  to view this content.