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)


    Code:



    Thanks

    Cristi

  • 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.