ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro add row and subtotal (https://www.excelbanter.com/excel-discussion-misc-queries/185591-macro-add-row-subtotal.html)

simplymidori[_2_]

Macro add row and subtotal
 
Sorry if I am posting multiple post. I have refreshed and cleared my cache
and not seeing my post. Earlier Jim had suggested to use my autsum in my
menu bar but this will not work for what I'm doing.

I have about 200 different sections and will need a macro that will add a
row and subtotal in that row in columns N,O,P,Q,R,S and T.

sample:

A

c
c
c
"blank cell" static data with original sum
:::add row forumla sum n column, sum o column, etc...thru T
e
e
e
e
e
e
"blank cell" static data with original sum
:::add row forumla sum n column, sum o column, etc...thru T

thank for any help or suggestions.


All times are GMT +1. The time now is 08:40 PM.

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