Hi All, Please help me in the second query that i have asked before, Lets suppose i am adding some rows after row 20th, it should take the 1st inserted row i.e. row 4, and paste in all newly created rows.
Please help as this is very urgent Regargs, Kunal Rout On Nov 17, 7:45 am, kunal <kunal.r...@gmail.com> wrote: > Hi All, > > Please let me know how to automate two things in excel: > 1. I need to give a number in A1 cell of 'Data' sheet (1st sheet) to add the > total number of rows in two sheets i.e. in sheets 'Data' and 'Analysis' > 2. All the formulas in the 'Analysis' sheets should automatically copied to > new generated Rows in second sheets ('Analysis' ) > > Thanks in advance, > > Regards, > Kunal > > Template.xls > 52KViewDownload -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe