Hi everyone.
I'm trying to create a worksheet which mimics a bank statement, so that the balance only appears against the last of several rows of entries for a single date.
To calculate a new balance after the day's entries I need to find the first non-blank cell above the result of the calculation in the Balance column: this will be the old balance. I can cope with the formula for making cells blank for all but the last of the rows containing the day's entries but I'm stumped by the new balance calculation.
I am reasonably comfortable working with formulae but I have absolutely no experience of VBA. Can I do what I'm trying to do without VBA?
Thanks for your help.
Bookmarks