Hi Guys,

I'm trying to search for text in one workbook and copy that row and paste it in a different workbook. this is what i have so far no error comes up but it doesn't paste the row in the new workbook. 

Please Login or Register  to view this content.
Once I have got that bit to work I'm going to need to move on to the next bit to search for another word copy that row and if the word doesn't exist to move on to the next word until all words are searched for.

Thanks

For in advance for any help

RandomPezzer