I have 2 marketing lists for my local area. They are in the same workbook as sheet 1 and sheet 2.
I need help to combine them into 1 woorksheet.
The problem I have is that the only common column is Column A (the Company Name) but not the same names but some are duplicates.
Sheet 1 has columns:
Company name ¦ Address 1 ¦ Address 2 ¦ Address 3 ¦ Town ¦ County ¦ Postcode ¦ Contact Title ¦ First name ¦ Surname ¦ Telephone number
Sheet 2 has columns:
Company name ¦ Address ¦ No. of Employees ¦ Postcode ¦ Telephone Number ¦ Type of Business ¦ Contact name
Is it possible to combine them and then look for duplicates and delete them?
I need to keep all information.
I have spent a few hours trying to do this manually and really didn't get anywhere.
You're help would be appreciated.
Bookmarks