any help from anybody please....? On Tue, Oct 4, 2011 at 6:29 PM, dguillett1 <dguille...@gmail.com> wrote:
> I, or some of the others can amend my code to do as desired. However, > again, I suggest you try this where you simply use filters on ONE sheet. > > *From:* Mr excel <excelkeec...@gmail.com> > *Sent:* Monday, October 03, 2011 11:56 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Update sheets on Enter > > huhhhhhh..My COmmunication is sucking day by day...sorry guillet.i could > not communicate to you properly....Hope this time i could make it clear.... > > From the Worksheet *MAKESHEETS example *given by you.You are > adding/creating sheets based on the REP cell...Here the macro starts only > when it is run manually. > Instead,i want the same type of solution.I.e. adding/creating sheets when > a new row with new data is entered into the main sheet. > > To elaborate more in detail,when a new row is entered after the 44th row > in row 45.the macro needs to be run automatically adding new worksheet based > on the column REP. > > If all the sheets are added to the workbook previously the REP in the new > row should be added to the existing worksheet which was added before the > present row.The new row should be added to the worksheet underneath the > previous row. > > > -- > > ---------------------------------------------------------------------------------- > 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
