I have two excel files.
file1 contains emp code,basic and
file 2 contains emp code ,dept code,emp name.
now i want to have update the basic in to the file2 (emp code,dept code,emp name,basic).
which syntax to be used in excel . please provide with example.
thanks in advance.