Help undertanding Subtotals

F

FurRelKT

Hello all, another newbe question,
I am unsure how to add the information above the subtotal to the
subtotal row.
I have this subtotal line in my code:
Selection.subtotal GroupBy:=3, Function:=xlSum, TotalList:=Array(14),
_
Replace:=True, PageBreaks:=False, SummaryBelowData:=True
I am totaling the amount in Column 14, but in columns 10-13,
i want to use the previous row's values and add those values to
the subtotal row. The rows change and are not always the same.

So, my row would be something like:
I: BLANK J: ABCD K:TBAVA L:THIS AND THAT M: SUPPORT N: 20
I: BLANK J: ABCD K:TBAVA L:THIS AND THAT M: SUPPORT N: 25
SubTotal N:45

So, instead of not seeing anthing in the subtotal besides subtotal and
the amount,
I want to copy the line above the subtotal paste it into the subtotal
line. So,
the subtotal line would read from the above example:
I: Subtotal J:ABCD K:TBAVA L:THIS AND THAT M:SUPPORT N:45

I have read some other posts concerning this issue and nothing i read
has
completed the solution. Any help would sure be appreciated.
 
V

via135

hi!

i think u r full tight!!

-via135

Hello all, another newbe question,
I am unsure how to add the information above the subtotal to the
subtotal row.
I have this subtotal line in my code:
Selection.subtotal GroupBy:=3, Function:=xlSum, TotalList:=Array(14),
_
Replace:=True, PageBreaks:=False, SummaryBelowData:=True
I am totaling the amount in Column 14, but in columns 10-13,
i want to use the previous row's values and add those values to
the subtotal row. The rows change and are not always the same.

So, my row would be something like:
I: BLANK J: ABCD K:TBAVA L:THIS AND THAT M: SUPPORT N: 20
I: BLANK J: ABCD K:TBAVA L:THIS AND THAT M: SUPPORT N: 25
SubTotal N:45

So, instead of not seeing anthing in the subtotal besides subtotal and
the amount,
I want to copy the line above the subtotal paste it into the subtotal
line. So,
the subtotal line would read from the above example:
I: Subtotal J:ABCD K:TBAVA L:THIS AND THAT M:SUPPORT N:45

I have read some other posts concerning this issue and nothing i read
has
completed the solution. Any help would sure be appreciated
 
F

FurRelKT

via135,
No clue as to what this even means:
i think u r full tight!!

???


Please direct me to any possible solutions so that i may read and try
to learn how to solve this question i have... thanks,
Keri
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top