![]() |
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 |
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