Results 1 to 9 of 9

Customer list phone number got all mixed up

Threaded View

  1. #1
    Registered User
    Join Date
    05-05-2017
    Location
    Canada
    MS-Off Ver
    2016
    Posts
    12

    Exclamation Customer list phone number got all mixed up

    So I have a File A with a complete list of (By column) customer codes, customer names, ..., ..., phone numbers, fax numbers, ..., ...

    When I sorted them all alphabetically, I must have not selected the phone numbers columns because they are now all mixed up.

    I have 4 other files with the customer codes, customer names, and correct phone numbers but each file has 1/4 of the customers.

    Is there a way I can copy from those smaller lists, and paste into the File A and it can find the correct customer codes and paste the correct phone numbers in the corresponding column?


    UPDATE: The file attached is an example of what I have. Sheet 1 is the sheet I want to put the correct phone numbers into, Sheet 2 and 3 are examples of the other files I have with the correct phone numbers corresponding to the correct customer names/codes.
    Attached Files Attached Files
    Last edited by VahidSamimi; 05-05-2017 at 12:21 PM. Reason: Update with dummy file example

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How do I add parenthesis to my phone number list -the area code?
    By Alan in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 07-03-2025, 10:38 AM
  2. Obtain customer phone number from ID in Excel
    By dkjMusic in forum Excel General
    Replies: 2
    Last Post: 08-31-2016, 04:43 PM
  3. [SOLVED] Phone number format - reference post (Formatting Textbox to type phone numbers only)
    By eddyrcabrera79 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-01-2015, 05:35 PM
  4. Customer phone numbers, some have zero's others don't!!
    By fRAiLtY- in forum Excel General
    Replies: 5
    Last Post: 03-05-2013, 08:32 AM
  5. Replies: 6
    Last Post: 02-14-2010, 02:29 PM
  6. comparing a phone number to an allowed list???
    By juzsp in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-20-2007, 12:00 PM
  7. List Box-phone number associated
    By R P in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-16-2005, 08:39 AM

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