When I export phone numbers from my contact data base it does not include the company name, it only contains the company abbreviation code. My thought is too match the abbreviations with the correct company names in sheet 2 and then insert a blank cell beside the abbreviation in sheet 1 and auto populate the correct company name beside each contact. There are multiple contacts for each company and finding and replacing the abbreviation with the company name would take entirely too long. I do not know how to do this but just matching the correct abbreviation to the corresponding company name and then auto fill in the cell beside the abbreviation seemed like a logical idea.
Thanks!
Thanks!
