How to copy data of one excel file to another excel file

Help Activities
, ,
1

Hello,

I want to copy the data of one excel file to another excel file.

let’s say in excel file 1 we have data in A,B,C,D,E Columns and in excel file 2 we have data in A,B,C,D Columns.

I want to compare A with A, B with B, C with C, D with D and only if all the data matches in the respective rows, then I want to copy the Data of E column in excel file 1 to excel file 2 column E

Thanks in advance.

2

@Sirimalla_Karthik_Chandra

It’s better if you can provide some sample Input and required output file to understand your issue

Thanks

3

Hi,

You can read both the XL sheets into 2 datatables and then use inner join condition on the A,B,C,D columns from both the tables. In output table you can have A,B,C,D,E columns.

Regards,
Sruthi YNM