Forum Discussion
I need a formula
ismat1950 Allow me to ask you a question. Why such a complicated approach where a list of transactions needs to broken up in small blocks of daily information? Probably something you need to recreate every month with no way to keep track of e.g. the whole year in one schedule.
I would transform the transactions list in Sheet2 to a structured Excel table and keep on adding transactions, day-by-day. Then you can build all sorts of reports off that table with Pivot Tables. No VBA, no complicated formulae needed. If you are not familiar with Pivot Tables you can learn more about them in the attached link. One of many on-line resources.
ismat1950 Not sure I follow. Where do you want to add the current balances?
The transactions table has the opening balances, all sales amounts and incoming funds from the bank. These three together make-up the current outstanding balance, as shown on the subtotal rows in the grand total column of the pivot tables. Of course, you can create pivot table with just the company as the row header and the amount in the value field. That will result in a list of current balances per company. Please clarify it that is not what you want.
Thanks a lot Mr. I appreciate your help.