How to find one value in one excel to another excel and once find that value in cell than automatically copy to particular two cell in same row

Hi @Raja.G

May be I am unclear with first question.
But you can use the the below activities for Question 1 and Question 2

But Here you have an activity “Copy ToClipboard” to copy the cell range inside excel and you can paste to new excel file using Paste Clipboard.

Regards
Balamurugan.S

1 Like