Excel search and copy

Hi all, I have 2 sheets in a workbook, from 1 sheet, from 1st column I need to take cell value search it in 2nd sheet, if the value is found I need to copy the value from 3rd cell and paste it in 1st sheet in 3rd column. and need to do it for all the rows.

1 Like

Hi @Mayank_mehta,

Welcome to UiPath Community!

  • To search the value, you can use the below activity. It will return the cellinfo and Row Index. They are array.

Video :

  • To Copy Paste you can use this one.

Sample :



Welcome to forums

You can search in my videos which you can get few info for your reference

Hope this helps you