Copy entire rows from one workbook to another workbook matching by one column

Help
,
1

Hi there,

Is that possible to run it out as I got two workbooks which is OldFile and NewFile. Both files having same column as image attaching below.

old
old1551×144 18.2 KB

This is how OldFile looks like.
new
new1476×326 26.5 KB

and this is how NewFile looks like.

My concern is that I want to copy the entire row from OldFile and paste it below each existing row in NewFile matching by cust_id (that I draw it with red frame).

Does anyone could assist me on performing this task? I would appreciate any assistance from you.
Thanks in advance.

Regards,

1 Like
2
  1. Read the oldfile and newfile.Then do the below operation,
    Screenshot
    Screenshot854×478 16.8 KB
1 Like
3

hi @Manish540
Use Excel application scope and read range activities to read both files? But how to read in two files in a scope?
Thank you for your sharing :')

1 Like