Stack multiple tables on top of each other in a single table

Remko · #1 04-17-2021, 08:07 AM

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?

p45cal · #2 04-18-2021, 03:24 AM

Quote:

Originally Posted by Remko

How can I make result table to always be correct without any manual calculation or use of macros?

Use Google sheets!

Code:

=SORT({Sheet2!A2:D;Sheet3!A2:D;Sheet4!A2:D}

or:

Code:

=query({Sheet2!A1:D;Sheet3!A2:D;Sheet4!A2:D},"select * where Col1 is not null",1)

p45cal · #3 04-18-2021, 04:18 AM

More seriously, I would have suggested Power Query but you need Office 365 for the Mac for that, so the next stage is likely, unfortunately, to be VBA (macro).
I did come across this page which starts off with "This wikiHow teaches you how to use the Power Query feature in Excel 2016 on a Windows and Mac computer." but I'm not so sure:
How to Activate Power Query in Excel 2016: 9 Steps (with Pictures)

I don't have a Mac so can't advise with any certainty, but if you find you can then that's the way to go.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Merging a table from multiple files into one table in a single file	LisaT	Excel	3	08-28-2020 06:42 AM
How to compile text from multiple tables into a cell in a nested table	jrooney7	Word VBA	2	03-11-2019 07:55 AM
Combine multiple tables into one pivot table in order to do trend analysis	marelisev	Excel	2	04-15-2017 08:30 AM
Copy table cell formatting across multiple cells / tables	pakistanray	Word Tables	2	10-31-2011 08:07 AM
Copying Multiple tables from excel into a single word document	dineshtgs	Word Tables	1	04-07-2011 01:27 AM