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