I'm attempting to create a macro (1st time) that will copy data from one worksheet and paste it into another. The problem I have is that I need to run this multiple times so the pasting event needs to occur on a new row each time. As it is, I can only paste new data over existing data, so I need code to find the next empty row. Here's what I have so far, which obviously doesn't work: 

Range("C19:C34").Select
    Selection.Copy
    ChDir "ProdMac14:Users:meddington:Desktop:IPA_ExcelFiles:"
    Workbooks.Open FileName:= _
        "ProdMac14:Users:meddington:Desktop:IPA_ExcelFiles:IPA End-User Results - All.xls"
    
        'find first empty row in database

    Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=True
End Sub
my next issue is that this macro will only operate to open the target worksheet to paste into, but I'd like it to activate if the worksheet happens to already be open.

Any help appreciated,

edd