Hi there,

I have 3 tabs on Excel for Mac in which I have 3 matrices, containing financial data of a self-made accounting program. All of them contain the same number of columns (4) and column header texts (Date, Ledger account, Description and Amount).

I want to put these 3 into a single table so I can easily create reports on that table. The problem is: these matrices keep expanding when I add new lines to my journals. How can I make result table to always be correct without any manual calculation or use of macros?