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