+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Find duplicates between worksheets and replace whole row where duplicates exist.

  1. #1
    Registered User
    Join Date
    07-13-2010
    Location
    England
    MS-Off Ver
    Excel 2007
    Posts
    1

    Find duplicates between worksheets and replace whole row where duplicates exist.

    Hi there, have used this forum before and have always found answers i needed by searching, however couldn't quite do it this time...So thought i'd sign up and ask!

    I have 2 separate worksheets; 'company1' and 'company2'. 'company1' is the smaller worksheet and contains a list of company names in column A. The subsequent columns are titled. address 1, address2, address3 etc. However these are all blank, i am missing all address information.

    'company2' is a larger worksheet. It is in the same format as 'company1'. However 'company2' is a more complete worksheet, thus it has address information for some of the companies in 'company1'.

    I want to search both sheets for duplicates found in the column company name. If there exists a match, then i want to delete the whole row in 'company1', and replace it with the matched row from 'company2'.

    Now 'company1' should have more address information.

    Any help greatly appreciated.

  2. #2
    Registered User
    Join Date
    07-13-2010
    Location
    Fort Myers, FL
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Find duplicates between worksheets and replace whole row where duplicates exist.

    I'm in the same boat except in my case I'm dealing with one company and two files. One file contains the marketing data while the second file contains the prices and weights. Normally this is not an issue except in this case the prices and weights file has 300 - plus more lines than the marketing data file.

    I need to find and any non-matching lines but cannot for the life of me figure out the formula.

+ 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