Starting a new calculation loop when a new entry in column A is reached

Hi everyone!

I would like to ReSample intervals in order to get a continuous serie. I also put a classification number next to the continuous serie.
I already managed to do this for 1 Name (PIET). Now I want to do the same with a second Name (HENK) in the database. For this I need the code to start a new loop, when a new name is found in the database (same as finding a '0' as top). I would like to have the new results in a new workbook with the name HENK. If possible I would like to have the results of PIET also in a new workbook with the name PIET.
I put my excel file in the appendix.

Current Code:

Please Login or Register  to view this content.

Anyone experience with this?