how to auto insert rows in Excel
Hello
I have a huge excel worksheet that I need to insert rows and subtotal between sections. For example: Class 11 Class 11 Class 11 Subtotal Class 12 Class 12 Class 12 Subtotal How can I automatically do this? Right now, the manual intervention takes a 1/2 day! Thanks for any insights tg |
Tanya
Have you taken a look at DataSubtotals? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "TanyaG" wrote in message ... Hello I have a huge excel worksheet that I need to insert rows and subtotal between sections. For example: Class 11 Class 11 Class 11 Subtotal Class 12 Class 12 Class 12 Subtotal How can I automatically do this? Right now, the manual intervention takes a 1/2 day! Thanks for any insights tg |
Data--Subtotals
http://www.officearticles.com/excel/...soft_excel.htm ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "TanyaG" wrote in message ... Hello I have a huge excel worksheet that I need to insert rows and subtotal between sections. For example: Class 11 Class 11 Class 11 Subtotal Class 12 Class 12 Class 12 Subtotal How can I automatically do this? Right now, the manual intervention takes a 1/2 day! Thanks for any insights tg |
All times are GMT +1. The time now is 03:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com