I have been using excel formulas to automate my work but I have failed on this one, therefore I am asking for VBA code. However if someone knows how I can produce my desired debtors status report using excel formula he or she can help me. I have attached excel sheet. Please not Sales rows and Receipts rows will keep expanding as I enter new transactions.
Thank you.
Thank you.