+ Reply to Thread
Results 1 to 2 of 2

Macro that matches columns and pastes to two new columns for eleven different users

  1. #1
    Registered User
    Join Date
    10-05-2012
    Location
    Longmont
    MS-Off Ver
    Excel 2010
    Posts
    30

    Macro that matches columns and pastes to two new columns for eleven different users

    Hello,

    In short, I need a macro that will find any value in column C (first user), match it with any value in column A (the master list), and then paste one instance of that value in column D along with the point numbers from column B. Rinse and repeat for all 11 users. In the attached, I went ahead and did a partial of what I'm trying to accomplish for Alex and Anna. The highlighting is strictly for visual purposes and will not be necessary for the final product. However, the double border line at the end of each list would be helpful (but also not completely necessary).
    Matching with names.xlsx

    I have tried a couple of different macros that others have posted on here. Being a VBA novice, though, I have had incomplete results.

    Thanks in advance for your help!
    Nick

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013
    Posts
    17,124

    Re: Macro that matches columns and pastes to two new columns for eleven different users

    Try
    Please Login or Register  to view this content.

+ Reply to Thread

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