Thanks for your reply... Can you please do a small favour for me.
Now I want to copy the same data not in to more sheets, it should be into different workbooks. Thanks and Regards, Naresh V, Sr Analyst, iSpace global services India pvt ltd. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Paul Schreiner Sent: Friday, September 09, 2011 9:42 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ vba help If you do it that way, you're going to skip some rows: first loop: i = 1, selects 1 to 200 i = i + 200 = 201 second loop: INCREMENTS i i = 201, for loop increments to 202, selects 202 to 401 i = i + 200 = 402 loop increments 402 to 403, selects 403-602 what you SHOULD use for the loop is: For I = 1 to 2000 step 200 that way, the loop is: I = 1 I = 201 I = 401 I = 601 etc. Paul ----------------------------------------- "Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can." - John Wesley ----------------------------------------- ________________________________ From: ashish koul <koul.ash...@gmail.com> To: excel-macros@googlegroups.com Sent: Fri, September 9, 2011 11:40:55 AM Subject: Re: $$Excel-Macros$$ vba help Sub breaksheet_data() For i = 1 To 2000 Sheets(1).Rows(i & ":" & i + 199).Copy Sheets.Add After:=Sheets(Sheets.Count) Cells(1, 1).Select ActiveSheet.Paste i = i + 200 Next End Sub On Fri, Sep 9, 2011 at 12:47 PM, naresh v <naresh.veerabo...@gmail.com<mailto:naresh.veerabo...@gmail.com>> wrote: Hi Group, I have one excel sheet with 2000 records. i want to split those records. those 2000 records should copy into moresheets for ex: main sheet -- 2000 records; sheet1 -- 1 to 200 sheet2 -- 201 to 400 sheet3 -- 401 to 600 . . . sheet10 -- 1801 to 2000 thanks in advance regards, naresh v -- ---------------------------------------------------------------------------------- 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<mailto:excel-macros@googlegroups.com> <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Ashish Koul akoul.blogspot.com<http://akoul.blogspot.com/> http://akoul.posterous.com/ akoul.wordpress.com<http://akoul.wordpress.com/> My Linkedin Profile<http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- 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<http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com<http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com<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 ________________________________ DISCLAIMER: This e-mail and any attachments are intended only for the individual or company to which it is addressed and may contain information which is privileged, proprietary, confidential and prohibited from disclosure or unauthorized use under applicable law. If you are not the intended recipient of this e-mail, you are hereby notified that any use, dissemination, or copying of this e-mail or the information contained in this e-mail is strictly prohibited by the sender. If you have received this transmission in error, please return the material received to the sender and delete all copies from your system. ________________________________ -- ---------------------------------------------------------------------------------- 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