Thanks sam first of all,for the kind reply.The code u posted is not the same i m looking for.I had explained what i m in need of...Kindly Read my last two updates & help me.. thanks...
On Thu, Oct 6, 2011 at 8:57 AM, Sam Mathai Chacko <samde...@gmail.com>wrote: > Isn't that what the code I posted does? > > Sam > > > On Thu, Oct 6, 2011 at 8:52 AM, Mr excel <excelkeec...@gmail.com> wrote: > >> Any ideas please..:? >> >> >> On Wed, Oct 5, 2011 at 5:30 AM, Mr excel <excelkeec...@gmail.com> wrote: >> >>> ADDITION: i just need the raw data to be exported to the respective >>> sheets based on REP column.No need of calculations of any kind.Hope i made >>> it clear... >>> >>> >>> On Wed, Oct 5, 2011 at 5:28 AM, Mr excel <excelkeec...@gmail.com> wrote: >>> >>>> I m interested in learning macros don.only reason i m asking repeatedly >>>> is this situation will be very helpful for me in my work.i just want the >>>> workbook to update sheets as and when a new row is updated in the main >>>> worksheet. >>>> >>>> I need to see the whole details when demanded in my work.the example you >>>> had provided is exactly the same i required.only change needed is that when >>>> a new row is added it should go to the exact worksheet(REP based). >>>> >>>> Oh my God!!!! now i understood why you people are offering me different >>>> solutions when i m explaining it in clarity.I had used the pivot table in >>>> the main sheet just to check whether all the rows updated are exactly the >>>> same.(counting no of rows).thats it. >>>> >>>> i had studied a little bit on searching in this forum.and learnt that i >>>> need to use the >>>> Worksheet Change Event.is it exactly the same don which i need to >>>> use.... >>>> >>>> Any ways,thanks for all the help given by you all...Especially DON...... >>>> >>>> >>>> >>>> On Tue, Oct 4, 2011 at 11:09 PM, Sam Mathai Chacko >>>> <samde...@gmail.com>wrote: >>>> >>>>> For the sake of an alternative, here's one using Pivots, though I would >>>>> go with Don. >>>>> >>>>> Regards, >>>>> Sam >>>>> >>>>> >>>>> On Tue, Oct 4, 2011 at 8:07 PM, dguillett1 <dguille...@gmail.com>wrote: >>>>> >>>>>> What is the reason that you do not like my idea of filtering? >>>>>> >>>>>> *From:* Mr excel <excelkeec...@gmail.com> >>>>>> *Sent:* Tuesday, October 04, 2011 8:42 AM >>>>>> *To:* excel-macros@googlegroups.com >>>>>> *Subject:* Re: $$Excel-Macros$$ Update sheets on Enter >>>>>> >>>>>> 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 >>>>>> >>>>>> -- >>>>>> >>>>>> ---------------------------------------------------------------------------------- >>>>>> 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 >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Sam Mathai Chacko >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> 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 >> > > > > -- > Sam Mathai Chacko > > -- > > ---------------------------------------------------------------------------------- > 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
