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
