Search and copy data from an excel file to another

Help
2

You can use Excel Application Scope with Read Range to read data from Database.xlsx sheet first. and store in a DataTable1
Then using another Excel Application Scope activity outside the above scope activity, read data from batch nr…xlsx sheet and store in DataTable2. Loop using for each row on DataTable2 you can use Lookup Data Table activity to search for your element in the data table - the CellValue output can be used to update your batch nr…xlsx sheet using Write Range activity.

Refer this link