Hello All,

I have two excel files. In both the excel files I have about 1300 rows
of data. These are different datas of the same material. For example
"material A" (the material information in both the files is in column
A) in file 1 is in row 13 and the same "material A" in file 2 is in
row 1201. I am trying to write a script which can take one file say
file 1 (for simplicity) and go to row 1 (of worksheet 1) and read the
material name (say "material xyz") and locate this material in file 2
(may be this same "material xyz" exist in row 1100 in file 2) and copy
a specific cell (say cell in column c, which means for this example,
cell c1100) to file1 in the same worksheet but in a specific column z
(so copy from file 2, cell c1100 TO file 1, cell z1). Can anyone help
me.

Thanks

Suresh