Compare String

Hell Every body
I want to compare the two strings in one worksheet and when the string is matched then open the new workbook automatically and the column next to the matched string is written to the new open workbook cell B1. The code is written below it just match the string, when the string is matched then it open the new workbook, but the next step in which i am fail is that i cannot copy the data from one workbook to other, and the sample workbook is also attached with this email.

Please Login or Register  to view this content.

Can some one please help me in this regard i really need the code