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