Macro copy rows based on specific column value

  • Hello,

    Based on the old thread:

    Macro copy rows to sheets

    The code it's working fine but I have problems when the sheet names exceeds 31 characters

    How can I modify the code to truncate the name below 31 chars even it's longer ?

    I got the following message: You typed an invalid name for sheet (pic attached)




  • cristu, you have been a member for over a year. It's about time that you read the Forum Rules and followed them.

    Any further infringements will result in your question being closed.

  • Try it this way...

    If I've been helpful, let me know. If I haven't, let me know that too.