It's doable. You use vba FIND to find Balance and make it a variable. Then
you use find again to find the next one then sum between then reset the
first one to the last one and do it again.

--
Don Guillett
SalesAid Software

"ploddinggaltn" wrote in message
...
I've looked at the posting and am questioning if this can be done based on
what I have read. Here is my situation.

I'm working with a very long spreadsheet that is updated daily with values
in column C for credits and Col D for debits. Each days entries are
separed
by an row that says "Balance" in Col B-Col C and D are empty and a running
balance is in column F. I need to total the amounts in col C but only for
the value that appear after the previous days "Balance" row and place the
sum
in Col G on the same row as the last entry in col C. Then I need to do
the
same for Col D and place that value in Col H on the same row as the last
entry in col D. If that isn't difficult enough, then I need to calculate
the
sum of the last amount in Col G & the last amount in col H and place that
value in col I. Since the speadsheet is updated daily, my row numbers are
variables. Is this too complex to code? Thanks for your assistance