Split the file

[Brunda]

Hi Chandoo,

Hope you are doing good,

Just wanted to know is der any way to spilt data present in same workbook of sheet 1 and sheet 2 for the particular person. when data is splitted it should contain all the details present in sheet 1 and sheet 2 in one workbook for each person.
lets have it like the names will be given in column I in both the sheets.
It would be greateful if it could be done, kindly help us on this.

Thanks.

 

[vletm]

Brunda
Many things are possible ...
... and more possible to solve
if You could upload a sample file with a sample data
and expected result from Your sample data.

 

[Brunda]

Brunda
Many things are possible ...
... and more possible to solve
if You could upload a sample file with a sample data
and expected result from Your sample data.

Hello,

Thanks for the quick response
FYI i have attached a sample data and how the output should look like

Thanks

 

[vletm]

Brunda
You sent Outputneeded.xlsx-file which has ankita-21st Aug's rows.
Is that all Your expected results?

 

[Brunda]

Brunda
You sent Outputneeded.xlsx-file which has ankita-21st Aug's rows.
Is that all Your expected results?

Hi,
From a bulk data when it's splitted among
In that way (outputneeded) I need each person file which ever the name present the column I
Each file should be saved in the name which is given in column I
Eg: ankita-21st Aug.xlsx ( and contains sheet 1 and sheet 2 data in it)
rahul-21st Aug.xlsx ( and contains sheet 1 and sheet 2 data in it)

 

[vletm]

Brunda
You could write correct details without digging, please.
This could do even this way
... there is Do_It-marco for You.
(( I do not use xlsx-file ))

 

[Brunda]

Brunda
You could write correct details without digging, please.
This could do even this way
... there is Do_It-marco for You.
(( I do not use xlsx-file ))

hi,
can we have a particular location given in place so that after it splits each file should get saved.

 

[vletm]

Brunda
As written in my previous reply's the first line ... please, reread it.
'a particular location' has given in that code.