That really helped and I would definatly turn up the code...but ihave a small issue again...can anybody help me with code as how to copy a string from one excel file , go to other excel file compare with like 50 strings and then append that string the value of the string which was there in the first excel sheet.