What is the reason that you do not like my idea of filtering? From: Mr excel 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 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
