Help! How can i copy the values after filtering?

[htoh2]

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

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/showthread.php?t=505226

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted:
http://www.mrexcel.com/forum/showthread.php?t=127080