+ Reply to Thread
Results 1 to 6 of 6

compare 2 sheets and remove identical rows in sheet 2

  1. #1
    Forum Contributor
    Join Date
    05-12-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    219

    compare 2 sheets and remove identical rows in sheet 2

    Hi all,

    I need help comparing two sheets, if any row in sheet2 already exist in sheet 1 , then cut and paste it into a sheet3

    Thank you very much

  2. #2
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: compare 2 sheets and remove identical rows in sheet 2

    What is the comparison based on? A particular column?

    "If ID in A1 on Sheet2 exists anywhere in column A on sheet1, then move the whole row from Sheet2 to Sheet3...repeat for all of Sheet2 column A values."

    Something like that?

  3. #3
    Forum Contributor
    Join Date
    05-12-2009
    Location
    US
    MS-Off Ver
    Excel 2003
    Posts
    219

    Re: compare 2 sheets and remove identical rows in sheet 2

    compare the whole row, (the data in each cell of that row)

  4. #4
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: compare 2 sheets and remove identical rows in sheet 2

    Hi VBisgreat
    This could be done with concatenation. How many columns are you talking about and how big are the files?
    John
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  5. #5
    Registered User
    Join Date
    12-03-2009
    Location
    France
    MS-Off Ver
    Excel 2007
    Posts
    4

    Lightbulb Re: compare 2 sheets and remove identical rows in sheet 2

    I agree with jaslake : you should concatenate all the cells in one.

    The syntax for the CONCATENATE function in Excel 2007 is:
    = CONCATENATE ( text1, text2, ... text30 )
    Text1, text2, ... text30 can be words, cell references, blank spaces, or numbers.

    When it's done, you can use this comparison service to find identical lines in both files.
    On step2, select the colum where you have made the concatenation in each file.
    Best regards
    Marc

  6. #6
    Forum Guru jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: compare 2 sheets and remove identical rows in sheet 2

    I don't know what comparator service is referenced in xlcomparator's post but a service is not required.
    John

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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