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!