sum currency value between empty rows

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top