Hi Danial,
You can see 14 order names in file of ‘Total order data’ then I want to order wise split data. For example output file of “BIIF_0811_0911_D_ShLead_1”. Similarly I want to 14 files just click in macro. Because I have spent lot time copy paste. -- -- One Team One Dream One Goal Warm Regards, Brajesh Kumar Porwal E-Mail :- brajeshkumarpor...@gmail.com 7503020750, "We can't Spell S_ccess without U" Life is Very beautiful !!! ¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling! `•.¸.•´. On Thu, Aug 11, 2011 at 1:49 PM, Daniel <dcolarde...@free.fr> wrote: > Hi,**** > > Can you explain a bit more ? there are 2 workbooks in your archive.**** > > Regards.**** > > Daniel**** > > ** ** > > *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* Brajesh Kumar Porwal > *Envoyé :* jeudi 11 août 2011 08:50 > *À :* excel-macros@googlegroups.com > *Objet :* $$Excel-Macros$$ Split data order wise New Excel workbook**** > > ** ** > > Hi Expert,**** > > ** ** > > I urgent need your help, because i want to create macro for split data. I > have more data in excel workbook so I want to split data order wise New > Excel workbook. Please find enclose example file.**** > > **** > > ** ** > > -- > -- > One Team One Dream One Goal > > Warm Regards, > Brajesh Kumar Porwal > E-Mail :- brajeshkumarpor...@gmail.com > 7503020750, > "We can't Spell S_ccess without U" > > Life is Very beautiful !!! > ¨`•.•´¨) Always > `•.¸(¨`•.•´¨) Keep > (¨`•.•´¨)¸.•´ Smiling! > `•.¸.•´.**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel**** > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel