Macro to Look for Name in Column and calculate other columns based on same Value

[bdunk]

I have a sheet with rows that may or may not have the same value in Column E. What I would like to have happen is to have a macro that will look in column E for like values. When it finds a different value insert a blank row below the last row with the value in Column E. In this new row total all values in Column D with like values in Column E. Total all values in Column M with like values in Column E. Total all values in Column N with like values in Column E. Copy the values from one row above this new row from columns A, B, C and I.

Thanks
Brian

 

[jbeaucaire]

Not sure you need a macro.

1) Highlight the data
2) Select Data > Subtotal

At each change in - set to the header for column E
Use function - SUM
Add Subtotal - check off the column headers for D, M and N.

That should get you 90% of the way there.

 

[bdunk]

Not sure you need a macro.

1) Highlight the data
2) Select Data > Subtotal

At each change in - set to the header for column E
Use function - SUM
Add Subtotal - check off the column headers for D, M and N.

That should get you 90% of the way there.

Thanks but there are just too many rows of data to try. Atleast if I could have something that would insert the blank row after the common value in Column E then total the columns specified above. That would get me going. Any thoughts?

 

[jbeaucaire]

Too many rows of data? This can be done on 1000s of rows of data all in one go. Follow the instructions given, especially #1.... highlight ALL the data. The subtotals will be inserted by adding rows using the column you set as the "at each change in" column, in your case that is column E. So everytime column E changes values, a row will be inserted, that is exactly what you're after. Then the "Add Subtotal" columns you indicate will get the SUMs, also exactly what you want.

I'm underlining how Excel already knows how to do what you want, you just need to highlight all the data first so it know how far to go.