Faced Problem while concentrate data with commas

[pchng2]

Hello to all experts,

I am totally new in handling excel, vba and appreciate if someone could help me with the following problem which I am facing currently.

I tried to transfer IDs with conditions fulfilled and concentrate them with commas to specific destination files, namely DestinationFile 2 and DestinationFile 3. However, I faced problem while transferring the data to one of the DestinationFile. Please view the images in the attached files, namely EndUser, DestFile2 and DestFile3 and you will see the image, named DestFile3 having an extra data of “xx4” circled in red.

The following are the codes I used:

1.For EndUser.xlsx

Please Login or Register  to view this content.

2.DestinationFile 2

Please Login or Register  to view this content.

3.DestinationFile 3

Please Login or Register  to view this content.

Please kindly advise me in identifying my mistakes. All i want is that DestinationFile2 and 3's output will be the same.

Appreciate all your help.
Thank you in advance
Regards,
Pchng

[Marcol]

Please wrap your code in code tags, before the moderators get you...

Forum rules

3. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # button at the top of the post window. If you are editing an existing post, press Go Advanced to see the # button.

You would do best to post a sample workbook showing Before and After rather than screengrabs.

It should clearly illustrate your problem and not contain any sensitive data.

Cheers

[royUK]

Please use Code Tags, not Quote tags in future

For information on how to use the forum please follow one of the links to our how to sections or frequently asked questions!
Navigation bar including the How to...? dropdown
How to videos
Frequently asked questions

[royUK]

You don't need to activate the workbooks,.
I can't see why you have separate Procedures

Please attach an example workbook