Copying specific rows from workbook containing data to a template workbook

[mattyp]

So I basically have a template workbook that the code is stored in. I need it to pull an entire row if Column C in workbook "rawdata" contains specific text, in this case "PRCH - Purchase".
I have never had to do anything like this before, it has always been working in the same workbook. Can someone tell me where I went wrong? It's failing at the 'mp = ...' line every time. There might be other errors in the code too, I just cannot resolve the first one! Any help is appreciated!

mp = Workbooks("rawdata").Sheets("Scorecard").Cells("C", Rows.Count).End(xlUp).Row
mp1 = Workbooks("template").Sheets("PRCH").Cells(Rows.Count, "A").End(xlUp).Row
 
 
 
For r = mp To 2 Step -1
    If Workbooks("rawdata").Sheets("Scorecard").Range("C" & r).Value = "PRCH - Purchase" Then
        Rows(r).Copy Destination:=Workbooks("template").Sheets("PRCH").Range("A" & mp1 + 1)
        mp1 = Workbooks("template").Sheets("PRCH").Cells(Rows.Count, "A").End(xlUp).Row
    End If
Next r

[alansidman]

The syntax for cells is cell(Row,Column)

You have it reversed in that line.

[mattyp]

The syntax for cells is cell(Row,Column)

You have it reversed in that line.

Thanks for catching that. I reversed it and I still get an 'object required' error on that line. Any ideas?

[mattyp]

Anyone see anything wrong? I have yet to figure this one out.

[alansidman]

It would be helpful if you posted the entire code and uploaded the workbooks associated with confidential data dummied up.

[mattyp]

It would be helpful if you posted the entire code and uploaded the workbooks associated with confidential data dummied up.

Sorry for some reason I didn't get an email that there was a response! This is all the code I have so far. Basically I need script that is in the "template" worksheet to pull data from the "rawdata" spread sheet. In the rawdata sheet, it's searching Column C for specific values. If it finds that value, copy the whole row to the template spread sheet, in a specific tab - "PRCH" is the pre existing tab in the template worksheet in this case.

I'm really a newb to this, but isn't the code above enough to do that?