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.

Try this

Please Login or Register  to view this content.

Hi Imran,

Appreciate your help in this. Just one issue.
The last row data is missing for all the names

Please Login or Register  to view this content.

Hi bakerman2

You knocked it..Appreciate your help in this.

I have data in other sheets also in the same workbook.
Now with this code, Say for Antony. File is created and from source file Sheet1 Antony data is being copied. This is good.

However is there any way to put condition, to check other sheets also in the source file. If Antony data is found in Sheet 2 , same data would copied to sheet 2 of Antony file.
Accordingly copy all the data from other sheets for Antony.

Like wise for patric etc.,

when i tried with this code, i can see "Sheet 2" data is getting erased. I know this is because my initial file didnt have any other sheets apart from sheet1. Apologise from my end.

Let me know if this is possible.

Originally Posted by prabhuduraraj09

Hi Imran,

Appreciate your help in this. Just one issue.
The last row data is missing for all the names

Working fine for me.extracting all records.