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.

--
Regards,
Tom Ogilvy

Kelly wrote in message
...
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