Copying a portion of data from an excel file

Automation Studio
1

Hi,
I need some help in selecting certain values from an excel file and copying it to other excel file. Any help would be appreciated. Thanks

2

Hi Suwal,

You can add the two excel as Excel application. Then while creating process you use Copy interaction to copy data from the cell you want to copy

Copy

Post you can add target excel and use Paste interaction to paste the data in target excel
Paste

3

Hi Suwal,
You can use Excel Recorder to record copy and paste action across two excels.

Thanks,
Sachin

1 Like