irc200
asked on
Excel 2003 VBA Specify multiple column subtotals
I have a worksheet containing 4 columns. I want to use the subtotal method of the range object. The third and fourth columns contain numeric data. I want the sum of each group for the 3rd column data and the max of each group for the 4th column data. Does anyone have have a VBA code snippet to accomplish this?
A B C D
x x 1 4
x x 2 3
x x 3 2
x x 4 1
------------------
Subtotal: 10 4
A B C D
x x 1 4
x x 2 3
x x 3 2
x x 4 1
------------------
Subtotal: 10 4
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hoping someone can pick this up from here
I will be away till Monday
I will be away till Monday
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've requested that this question be closed as follows:
Accepted answer: 0 points for irc200's comment http:/Q_27297615.html#36510437
for the following reason:
My solution solved my specific instance of the problem
Accepted answer: 0 points for irc200's comment http:/Q_27297615.html#36510437
for the following reason:
My solution solved my specific instance of the problem
irc200's question ended with "Does anyone have have a VBA code snippet to accomplish this"
As irc200's solution does not seem to be a VBA solution, it can not answer the question
As irc200's solution does not seem to be a VBA solution, it can not answer the question
ASKER
A B C D
z x 1 4
z x 2 3
z x 3 2
z x 4 1
---------------------
Subtotal x: 10 4
z y 6 9
z y 7 8
z y 8 6
z y 9 7
---------------------
Subtotal y: 30 9
GrandTotal Z: 40 9