I need some VB script please

R

rlee1999

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
 
E

EagleOne

Robert,

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

EagleOne
 
R

rlee1999

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

~Robert
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some VB script, please 2
VB Script to insert row and calculate a range 3
VB Script reference cells for in current table? 1
Insert Row and Countif Macro 1
Copy rows to new sheet based on value in column A 0
Yet More Excel VBA Help Please 0
Sum to a mid point in a dynamic table 2
How to filter rows data based on background color of individual cells 3

Top