Please help me to modify the code copy/paste/transpose

[tuongtu3]

Hello All,
I'm trying to modify the code (got help from this forum) to make it work for my workbook but did not work. Please take a look at sample in attached and help me out. (input is in Data ws and output is in result ws) and the result should be exactly like the "sample" worksheet.

Best regards,
tt3

Below code is for reference only & you can make it work

Please Login or Register  to view this content.

[AB33]

Try this one

Please Login or Register  to view this content.

[tuongtu3]

Hello AB33,
Sorry for the late response. Is it possible to add border for each of this line:

Please Login or Register  to view this content.

Regards,
tt3

[AB33]

Add this line

Please Login or Register  to view this content.

After this line-just below it

Please Login or Register  to view this content.

[tuongtu3]

Hello AB33,
That works perfect and how to change the font size from 10 to 8 if text is more than 200 chars in this line (if seperate code will be ok)

Please Login or Register  to view this content.

Regards,
tt3

[AB33]

Hmm!
This may be you have a value in merged cells? Am I right?

[tuongtu3]

Yes, this value in a value cells.

Regards,
tt3

[AB33]

tt3,
Sorry! Dealing with merged cells is a nightmare to say the least. This question is also not related to your original request, so perhaps you should close this thread and start a new one.

[tuongtu3]

AB33,
Thank you very much for your time and help.

Regards, tt3

[AB33]

tt3,
You are welcome!