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 :

Regards
Balamurugan.S

@Mayank_mehta

Welcome to forums

You can search in my videos which you can get few info for your reference
https://forum.uipath.com/t/tutorial-how-to-check-a-string-is-present-in-excel-sheet-part-1/243696/2

Hope this helps you

Thanks