Thanks for your reply Trowa, but I need to transfer data across the files,let me explain it to you again
1. I have two spreadsheets Test1.xls and Test2.xls
2. Test1.xls has multiple worksheets with each cell having some values
3. Test2.xles has multiple worksheets as well which matches Test1.xls
4. If I alter a value in a cell in Test1.xls, the corresponding cell in the Test2.xls has to change as "Taken".
eg: Test1.xls --> Sheet1.A2 -" if I enter a value as Sam"
Test2.xls ---> Sheet1.A2 - should display "Taken"
[the data has to change in the same address location]
so if i alter any cell in Test1,it should change in Test2.