+ Reply to Thread
Results 1 to 2 of 2

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

  1. #1
    Registered User
    Join Date
    11-12-2019
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    2010
    Posts
    1

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

    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.PNG

    This is how OldFile looks like.

    new.PNG

    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,

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Macro VBA Copy entire rows from one workbook to another workbook matching by one colum

    Hi and welcome
    why not merge the sheets then sort them by cust_id ?
    You can use this simple add-in or code on the same webiste

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 18
    Last Post: 10-08-2017, 04:17 AM
  2. [SOLVED] search range in workbook 2 for matching value from column in workbook 1 then copy row
    By morbenforsen in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-24-2017, 11:16 AM
  3. Macro to copy entire columns with matching dates from another workbook
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2012, 01:23 PM
  4. VBA Search workbook for user value, copy/paste entire row to last sheet for matching
    By jasonkrispy21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-22-2012, 03:42 PM
  5. Replies: 14
    Last Post: 03-16-2011, 11:40 AM
  6. Macro to copy entire group of rows to another worksheet and another workbook
    By exc1967 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-27-2011, 04:52 PM
  7. Copy values(rows & column) from one workbook from Another workbook
    By ananthakumar.e in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-05-2008, 09:33 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1