Copying specific rows from workbook containing data to a template workbook

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!

Please Login or Register  to view this content.

Originally Posted by alansidman

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?

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

Originally Posted by alansidman

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?