Excel Automation between sheets

Help Activities
, , ,
1

Hi,

i have two excel files
i want to find some column names from file 2 which is similar to file 1 and copy all similar column values from excel file 1 to excel file 2

Could anyone help how to complete this!?

2

Hi @jai_kumar2 ,

Could you maybe provide us with Screenshots of the Input and Output Excel files ?

In this way, we will be able to Identify the Logic needed faster and suggest a Better Solution?

3

@jai_kumar2 , Suggesting you to try the Vlookup activity. It will help get the rows from Another excel based on the matches.