Look: your comments don't help much to understand you, but your macro -directly- doesn't help at all.

I suggest you upload a workbook to the Forum again, but this time with two pages:

- On the first sheet, show us what you have to process.
- And on the second page show us the complete expected result.

Maybe this is how it can be understood.