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.
This is how OldFile looks like.
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.