One workbook to another workbook copy and paste activites

[Vijayakumar_Arumugam]

Hi guys,

My project is to take copy data from 10 different files and paste in one master file.

Are there any custom activities that help this process and is someone has any example workflow that helps me to work in this process?

thank you so many guys.

[bcorrea (Bruno Correa)]

Hi, that will depend on the format of this 10 files and the master file, if they all have the same format, you will need to open each of the 10 files, use read range and write range 10 times to create the new one.

[Srini84 (Srinivas)]

@Vijayakumar_Arumugam

Check attached

ExcelMergeAndFormat.zip (41.9 KB)

Mark as solution if this helps

Thanks

[balupad14 (Balamurugan)]

Hi @Vijayakumar_Arumugam,

Here is an activity to copy past workbook to workbook. It will copy only the values.

How to copy one excel row to paste in another excel update row

Hi @Raja.G, You can use the Copy ToClipboard and Paste Clipboard activity that i have attached it here. [image] Regards Balamurugan.S

Note
Upload the latest package in the same thread.

Thank you
Balamurugan.S