Copying Info From One Sheet & Posting Below Info on Another Sheet

After months of searching for a solution...I have yet to discover one that works. Here is my VBA problem:

Copy information from cells A5 to N37 from a sheet titled "Exam"

Paste the information onto sheet titled "Copies"

As the process repeats by means of pressing a button, all new information from cells A5 to N37 on sheet "Exam" must paste below any information contained on the sheet titled "Copy". (This way the information being pasted does not write over any previous information)


So after the first click:

"Exam" A5:N37 are transfered to "Copies" A5:N37

On the next click:

"Exam" A5:N37 are transfered below to "Copies" A38:N70

Etc.

Etc.

Maybe:

Please Login or Register  to view this content.

Unfortunately, each paste copies directly over the last one

I need the paste to go below in order for the information above to be preserved.

Thats what it should be doing. Unless Column A on Sheets("Copies") is empty?

I have the macro assigned to a button on Sheet "Exam"

Copies is originally blank

Every time a hit the button on "Exam"

The info keeps pasting over the first set of information on "Copies". It never shifts down.

This gets me really close....But the info continuously pastes above and not below

Sub CopyOver()

Application.ScreenUpdating = False
For j = 5 To 38 'Or however many rows u have
On Error GoTo Err_Execute
Sheets("Exam").Rows(j).Copy
Sheets("Copies").Rows(j).Insert Shift:=xlDown

Next j
Application.ScreenUpdating = True


Err_Execute:
If Err.Number = 0 Then MsgBox "Data Recorded" Else _
MsgBox Err.Description


End Sub

Maybe:

Please Login or Register  to view this content.

This still does not get the results I need. The ongoing issue is always that every time the information is copied and pasted the original information shifts down and the new information is pasted above and not below. This seems like an easy fix, but I am truly baffled.