+ Reply to Thread
Results 1 to 1 of 1

Compare data between 2 columns and copy entire row into another sheet based on new record

  1. #1
    Registered User
    Join Date
    01-06-2014
    Location
    Hyderabad
    MS-Off Ver
    Excel 2010
    Posts
    29

    Compare data between 2 columns and copy entire row into another sheet based on new record

    Dear Team,

    with attached the macro sheet, I am able to compare two columns from two different sheets and copy the duplicate records into another sheet.

    But, I want the code to copy the entire row from source sheet if any record is not found in master data sheet).

    Ex: If 123 is there in Source file under any column and the same 123 is not found in Master data sheet, Code should copy entire row which has 123 in Source file and paste in another sheet.

    Hopw this will help you to modify the code.

    Looking forward for your help.

    Thank in advance for your swift help

    Kind Regards,
    Chandru
    Attached Files Attached Files

+ 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. Compare cell from two sheets, copy entire row to current sheet
    By nguerra in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-09-2014, 02:00 AM
  2. [SOLVED] Compare columns and copy entire row
    By twhite79 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-02-2013, 09:21 AM
  3. Copy columns (with formatting) based on data in another sheet
    By jcfransen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-08-2012, 05:53 AM
  4. Compare Values in 2 columns and Copy the entire row upon match
    By tachytank in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-07-2011, 01:42 AM
  5. Macro to filter based on identical column data as opposed to entire record
    By marielb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-27-2007, 12:27 PM

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