Copying Excel data from one workbook to another


I currently have a large excel workbook and want to divide up the data between sheets in another workbook.

I want to divide up the data based on company name. Would anyone know how to do this? I have searched the forum and could not find anything on it.


@Cormac, Here we have ,

Copy dataTable row to another dataTable - #2 by Sachin_Desai

Dom :slight_smile:

Hi @Cormac,

I don’t know you got the solution or not. But the below activity can fix you problem. It has an activity called “Copy data”. It copies the data from excel.