Forum Discussion
Summary Sheet Problems
So, I have an Excel 365 workbook with multiple sheets. I use it to track monies banked into a single bank account but for multiple purposes (rent, comms, clothing etc). Each sheet has a balance colum...
Lanmeister Without having seen your sheets I would recommend to put all your transactions together in one single sheet and add a column to indicate the purpose of the transaction. Then you will have the possibility to create sort, summarise, filter or create reports from that single data base, using PivotTables SUMIF formulae, filters, sub-totals etc.