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
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