• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Split the file

Brunda

Member
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.
 
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
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
 

Attachments

  • dataprovided.xlsx
    11.5 KB · Views: 5
  • Outputneeded.xlsx
    9.9 KB · Views: 4
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)
 
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 ))
 

Attachments

  • dataprovided.xlsb
    23.8 KB · Views: 7
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.
 
Brunda
As written in my previous reply's the first line ... please, reread it.
'a particular location' has given in that code.
 
Back
Top