how to search for contents,copy text from one excel file to another excel in vbscript

say i have two excel files ,file1 and file2. file1 has coumn1-name/id,column 2-text in chinese,col3-text in french etc. now i have to search if name/id of file1  is present in file2. if present i ...