I need some VB script please
 

I have 22 different classes in Column F, each class may have 1-25 item rows.
I need to locate the last row of each class and insert a row below it (22 new
rows inserted throughout the sheet). Then I need it to sum the dollar amounts
located in Column AI in the new row for all of the items in each class.

I hope you can help.

Thank you,

~Robert

I need some VB script please
 

Robert,

If your data in column F is sorted, then you could use Subtotals on
Column A for each change in column F

EagleOne


rlee1999 wrote:
I have 22 different classes in Column F, each class may have 1-25 item rows.
I need to locate the last row of each class and insert a row below it (22 new
rows inserted throughout the sheet). Then I need it to sum the dollar amounts
located in Column AI in the new row for all of the items in each class.

I hope you can help.

Thank you,

~Robert

I need some VB script please
 

Wow, I was way overthinking this one! Thanks for your help. A simly perfect
solution!

~Robert

"EagleOne" wrote:

Robert,

If your data in column F is sorted, then you could use Subtotals on
Column A for each change in column F

EagleOne


rlee1999 wrote:
I have 22 different classes in Column F, each class may have 1-25 item rows.
I need to locate the last row of each class and insert a row below it (22 new
rows inserted throughout the sheet). Then I need it to sum the dollar amounts
located in Column AI in the new row for all of the items in each class.

I hope you can help.

Thank you,

~Robert