ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Summing rows (https://www.excelbanter.com/excel-programming/289176-summing-rows.html)

Kelly[_7_]

Summing rows
 
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


Tom Ogilvy

Summing rows
 
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





All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com