VBA to match corresponding name and add value

  • I'm in need of a VBA script that adds a value to match a corresponding list.


    Here is a before and after example of what I'm looking for.
    On Sheet1, I have 2 columns. Column A is a list of text / names, Column B is a value.


    Bob 20
    John 15
    Marry 6
    Trevor 3


    On Sheet2 I have another list of names, In Column A.


    Tom
    Sue
    Bob
    Jarred
    Marry
    Rick
    Trevor
    John


    I need VBA that will match their corresponding name in Column A and add the same value, from Sheet1 to Sheet2, Column B. ..... to look like the following:


    Tom
    Sue
    Bob 20
    Jarred
    Marry 6
    Rick
    Trevor 3
    John 15


    Thanks!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!