Greetings to all of the experts,
i'm new to vba. Experts , pls guide me, thanks in advance!
I have a requirement to copy the values. I shall give an illustration
I have these 2 columns of data in my LookupFile.xls, as follows:
Country code Company Code
BB1 123
BB1 234
BB1 345
BB1 567
BB2 789
I also have these 2 columns of data in my Enduser.xls, as follows:
Country code Company Code
BB1
BB2
BB3
So, i have a requirement such as when i filter Country code ="BB1" in my LookupFile.xls , the values of company code (123,234,345,567) will be populated into company code column for country code ="BB1" in my Enduser.xls, with the values concatenate together with a comma.
Pls help on How can i go to this.
Thank you
Best regards,
htoh2
i'm new to vba. Experts , pls guide me, thanks in advance!
I have a requirement to copy the values. I shall give an illustration
I have these 2 columns of data in my LookupFile.xls, as follows:
Country code Company Code
BB1 123
BB1 234
BB1 345
BB1 567
BB2 789
I also have these 2 columns of data in my Enduser.xls, as follows:
Country code Company Code
BB1
BB2
BB3
So, i have a requirement such as when i filter Country code ="BB1" in my LookupFile.xls , the values of company code (123,234,345,567) will be populated into company code column for country code ="BB1" in my Enduser.xls, with the values concatenate together with a comma.
Pls help on How can i go to this.
Thank you
Best regards,
htoh2