Summing rows

  • Thread starter Thread starter Kelly
  • Start date Start date
K

Kelly

I am trying to sum totals where I have the same name in
mulptiple rows.
I want to compare the previous row with the present row
based first on one column and then another and where the
two rows are different I want to insert a row and insert a
total for that name.
I am not good with VBA but I want this to be part of a
current macro.
How do I go about doing this in VBA?

Any help would be great.
Thanks
Kelly
 
Are you familiar with Data=>subtotals. This does what you describe. If you
want to apply it with a macro, you can turn on the macro recorder while you
do it manually.
 
Back
Top