View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
simplymidori[_2_] simplymidori[_2_] is offline
external usenet poster
 
Posts: 23
Default Macro to AddRow and Subtotal

I have about 200 different sections in a single worksheet and will need a
macro that will add a row and keep a subtotal forumla to sum 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.