macro help?
 

I want to write a macro that sorts a spreadsheet on say columns 'c'.
"C" will have various duplicate values,
I want to group on these vlaues then insert serveral rows betwee
each group and do sum and average on 2 of the columns in th
spreadsheet.. I can do the sort but can not seem to find a way to brea
the groups out..
Can someone point me in the right
direction?

thanks
larr

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

macro help?
 

Have you consider the Data, Subtotals feature?

--
Jim Rech
Excel MVP

macro help?
 

Simple,

thanks Jim


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements