Hi all,
First, I'm running on MS Office Pro Plus 2016.
I have two sheets, (sheet1) is a list of email addresses in column A.
The second sheet (sheet2) has in column A a list of values, and in column B is the corresponding email address associated with the value in column A.
My goal here is to create a VB script that will match the email address in sheet1 column A with the email addresses in sheet2 column B, then give me the output of total unique values based on each matching email addresses in column B sheet1. I sure hope that makes sense. Thank you
First, I'm running on MS Office Pro Plus 2016.
I have two sheets, (sheet1) is a list of email addresses in column A.
The second sheet (sheet2) has in column A a list of values, and in column B is the corresponding email address associated with the value in column A.
My goal here is to create a VB script that will match the email address in sheet1 column A with the email addresses in sheet2 column B, then give me the output of total unique values based on each matching email addresses in column B sheet1. I sure hope that makes sense. Thank you
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | Unique | |||
2 | email1@email.com | |||
3 | email2@email.com | |||
4 | email3@email.com | |||
5 | email4@email.com | |||
6 | email5@email.com | |||
Sheet1 |