Split comma separated entries to new rows

Try This Code

Please Login or Register  to view this content.

Hi, thank you for your help. We are almost done. I'm not receiving the correct output (I just realized the post above is not showing correctly the columns), please see attached the sheet, I need the output as attached. Thanks again.

Ty This then:-

Please Login or Register  to view this content.

mehmetcik and Jacc, thank you, thank you!!!!! Very helpful. I appreciate your help )))))

Hello,

This code works splitting comma-separated entries to new rows, except I need it to move the entire row down, not just the cells in column 'B' down. Can anyone add to this code so that the rows move down as well?

Thank you

A before/after example workbook would be quite useful for us to see exactly what you mean for your question. See the yellow boxed area at the top of this webpage for instructions on how to include a sample workbook in your message.