I am sure most of you macro whizzes know the answer to this one, but
since i am basic I kindly ask assistance.

My situation is I am trying to create a macro to that will give me the
sum of columns G-AF. I need to get the summary for 3 subtotal lines
and one grand total line of which the rows are dynamic and will change
each day.

The conditions are Line Total 1 should be a summary of all rows above
it. Line Total 2 should be a summary of all rows above it. Line Total
3 should be a summary of all rows above it. Grand Total row should be a
summary of Line Total 1 + Line Total 2 + Line Total 3.

Any help would be greatly appreciated.


--
waynehinds
------------------------------------------------------------------------
waynehinds's Profile: http://www.excelforum.com/member.php...o&userid=25331
View this thread: http://www.excelforum.com/showthread...hreadid=519631

Hello,

Why don't you take a look at Tom ' s solution ...
http://groups.google.com/group/micro...8cc71ff564b790

HTH
Cheers
Carim

From what i could see the information only discussed summing one row
total. In my case I am looking for three subtotals and then a
grandtotal formula of the three subtotals.


--
waynehinds
------------------------------------------------------------------------
waynehinds's Profile: http://www.excelforum.com/member.php...o&userid=25331
View this thread: http://www.excelforum.com/showthread...hreadid=519631