Macro Loop and Paste in next empty row

Hi All,
I was hoping you could help, as Im new to macros etc...

I recorded a macro, and I need it to loop AND to paste the next set of results in the next empty row...

Im guessing this is pretty basic stuff, as Ive seen countless threads etc giving examples, but I just have not managed to get any to work :0s

Could you help please?

The macro recorded is...

Sub reformat_data()
'
' reformat_data Macro
' Keyboard Shortcut: Ctrl+p
'
    Range("A2:G2").Select
    Selection.Copy
    Sheets("Sheet2").Select
    Range("C2").Select
    ActiveSheet.Paste
    Range("C5:J37").Select
    Application.CutCopyMode = False
    Selection.Copy
    Sheets("Sheet4").Select
    Range("A2").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Range("A35").Select
End Sub

When it loops, I need it to move down to the next A*:G* range until it hits an empty 'range'. The data copied from range C5:J37 then needs to be pasted in Sheet4, but in the next empty row.


Any ideas?


PS - sorry about not formatting the post correctly (earlier)