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
