Col A - username
Col B - Full Name
Col C - Email address
Col D - Phone number
Sheet 2 contains the following:
Col A - Active Directory group name
Col B - user name
I require a macro/formula to look at the username in Sheet 2, col B, find it in Sheet 1 Col A, and then copy the contents of Columns B, C and D back to Sheet 2, Columns C, D and E
The end result is that Sheet 2 will be populated with the AD Group Name, Username, Full Name, email addy and phone number.
Hope you can help.
Regards
Dittdott
Related:
Copying Excel data from one sheet to another based upon contents of a cell