sum currency value between empty rows

P

ploddinggaltn

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
 
D

Don Guillett

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top