Hi Experts,
Please would really appreciate an VBA help here.
Trying to remove duplicate from the columnC cell1 in comparison with columnB cell1 in pivot, the data format in each cell of both the column are below.
Pivot Column B cell 1 contains multiple users> rahim;josh;nick;abdul;raj;smith;stacy
Pivot Column C cell 2 contains multiple users>john;crandell;ajay;stacy;raj;jacob;rodney
From the example above my objective is to remove duplicates from column c, which are Stacy; raj.
The range of the pivot for column b:c is 500.
Please could someone help me with a vba for this. Would be a real magic to me, if the duplicate of c is remove and the B cell1 details would be picked as email contacts for TO, C details would be picked as Cc. 1 email for each row. So if I have 500 rows 500 emails with B2 details in To and C2 details in Cc after the duplicates are removed.
Please advise on some tips for an VBA script for these
Jason
Please would really appreciate an VBA help here.
Trying to remove duplicate from the columnC cell1 in comparison with columnB cell1 in pivot, the data format in each cell of both the column are below.
Pivot Column B cell 1 contains multiple users> rahim;josh;nick;abdul;raj;smith;stacy
Pivot Column C cell 2 contains multiple users>john;crandell;ajay;stacy;raj;jacob;rodney
From the example above my objective is to remove duplicates from column c, which are Stacy; raj.
The range of the pivot for column b:c is 500.
Please could someone help me with a vba for this. Would be a real magic to me, if the duplicate of c is remove and the B cell1 details would be picked as email contacts for TO, C details would be picked as Cc. 1 email for each row. So if I have 500 rows 500 emails with B2 details in To and C2 details in Cc after the duplicates are removed.
Please advise on some tips for an VBA script for these
Jason