Summing with Dynamic Data

[waynehinds]

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.

 

[Carim]

Hello,

Why don't you take a look at Tom ' s solution ...
http://groups.google.com/group/micr...9a648/5f8cc71ff564b790?hl=en#5f8cc71ff564b790

HTH
Cheers
Carim

 

[waynehinds]

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.