Copy cell values from one excel to another while matching column and row name


I have 2 different excel workbook. What I would like to achieve is to transfer data over to another workbook; while matching the column and row name. So for example, when copying data of row 3 over from first workbook (as shown in first screenshot), uipath should help to make sure that it matches row name B and the column name One, Two , Three , Four and Five (as shown in 2nd screenshot).

Hi @Joshhere,

To copy the cell one excel to another excel you can use this activity.

  • to copy the cell to clipboard
  • To past another excel file.

Thank you

hi @balupad14, thanks for your reply! by any chance do you have a work file where i can use to see how you do for matching? So like the ones as described in my question.