I'm having some trouble trying to figure something out.
I have an Excell workbook with 2 worksheets.
Each worksheet contains 2 columns of data.
1st column (in both worksheets) is a column with usernames
2nd column (in both worksheets) contains different numbers
The 1st column in the 2nd worksheets contains more usernames than the
1st column in the 1st worksheet.
What I need to do:
I need to transfer the values of the 2nd column of the second worksheet to a
new column in the 1st worksheet.
Sounds easy but:
I need to compare the usernames of the 1st column in the 2nd worksheet to the
usernames in the 1st column of the 1st worksheet. If there are usernames in the 1st
column of the 1st worksheet that don't appear in the usernameslist of the 2nd worksheet
the 2nd column of the 2nd worksheet needs to skip that username.