Hi Ashish,
Thanks for your effort. I guess something is missing in this macro.
Its not working properly. Please help me out.
Regards
Aparna
On Sep 8, 8:19 am, ashish koul <koul.ash...@gmail.com> wrote:
> hi
>
> try this assuming sheet1 is master see if it helps
>
> Sub Macro1()
> Dim i, z, k As Long
> z = 1
> k = 50
> For i = 1 To 50
> Sheets(1).Select
> Rows(z & ":" & k).Copy
> Sheets.Add After:=Sheets(Sheets.Count)
> Sheets(Sheets.Count).Select
> Range("a1").Select
> ActiveSheet.Paste
>
> z = z + 50
> k = k + 50
>
> Next i
>
> End Sub
>
> --
> Regards
>
> Ashish Koul
> 9953979291
> *akoul*.*blogspot*.com <http://akoul.blogspot.com/>
> *akoul*.wordpress.com <http://akoul.wordpress.com/>
> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830>
>
>
>
> On Wed, Sep 8, 2010 at 12:16 AM, api gud <aparnagud...@gmail.com> wrote:
> > Hi,
> > I have a data entry problem in excel. I have entered some 2500 entries
> > ( 2500 rows and 8 columns) in the master sheet. Now I want 50 more
> > sheet with just 50 entries on each sheet., resp. Please help me with
> > any model/formulas/macro etc. that will fill these 50 sheets on its
> > own the moment I enter the data in the master sheet.
>
> > I hope I am clear in writing my exact problem.
> > This problem may be very trivial for all excel experts, but for me its
> > a problem as I am a novice in this area. I would appreciate your kind
> > help.
>
> > Regards
> > Aparna
>
> > --
>
> > ---------------------------------------------------------------------------
> > -------
> > 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 athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
> > To post to this group, send email to excel-macros@googlegroups.com
>
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
>
> > We reach over 7000 subscribers worldwide and receive many nice notes about
> > the learning and support from the group.Let friends and co-workers know they
> > can subscribe to group at
> >http://groups.google.com/group/excel-macros/subscribe
>
>
>
> testsheets.xlsm
> 43KViewDownload
--
----------------------------------------------------------------------------------
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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 7000 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
