I maintain a spreadsheet with multiple accounts, and I need to spend against accounts in the order they were received. For example, if my operating expense for August is 56K, I need a function or code that would draw funds from first account, if the account does not have sufficient funds to cover August bill, goto next account and so on until the August bill is covered. If there is a balance from the last account used, it would be applied to the following month.
Thanks in advance for any help or suggestion!
Screen Shot 2016-08-03 at 9.01.25 AM.png