Help needed - List of names new excel to be created and saved

Hi all,

Need some help, I have file with list of repeated name like below.

I need vba solution, to create new excel file in the name of each of the names and paste their relevant data.
This file need to be saved in some destination folder.

As per below data, there are 3 names Michele , Antony and Patric
So 3 files to be created and saved in destination path.
In Michele file, only Michele data should be reflecting with Header
so as for Antony and Patric.

( Attached sample file )

Name No of task
Michele 12
Michele 23
Michele 34
Michele 3
Michele 5
Michele 4
Michele 45
Michele 56
Michele 44
Michele 34
Michele 2
Antony 23
Antony 12
Antony 34
Antony 45
Antony 656
Patric 65
Patric 67
Patric 88
Patric 67



i would need help on this.