Results 1 to 3 of 3

Trying to get a macro that would match up 3 sets of data

Threaded View

beepbeep27 Trying to get a macro that... 05-10-2012, 10:58 AM
beepbeep27 Re: Trying to get a macro... 05-11-2012, 10:00 AM
xlsaccountant Re: Trying to get a macro... 05-11-2012, 01:36 PM
  1. #1
    Registered User
    Join Date
    04-18-2012
    Location
    indiana, usa
    MS-Off Ver
    Excel 2010
    Posts
    35

    Trying to get a macro that would match up 3 sets of data

    I am trying to match phone logs against data that a user says they have called. One sheet contains the phone logs, the other sheets contains the user info that has when they said they called and what number they called. I need to return in the 3 columns in the sheet if it finds the phone number against the call log, how long the call lasted, what # was called, and what date it was called on. Another issue is the phone number can be altered on the call log, so one would have "555-555-5555" but the call log could have it as +1 (555-555-5555). Any ideas?

    Sheet posted is basically what i want to happen, thanks as always everyone!
    Attached Files Attached Files

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