Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-17-2021, 08:07 AM
Remko Remko is offline Stack multiple tables on top of each other in a single table Mac OS X Stack multiple tables on top of each other in a single table Office 2016 for Mac
Novice
Stack multiple tables on top of each other in a single table
 
Join Date: Apr 2021
Posts: 1
Remko is on a distinguished road
Default Stack multiple tables on top of each other in a single table

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?
Reply With Quote
  #2  
Old 04-18-2021, 03:24 AM
p45cal's Avatar
p45cal p45cal is offline Stack multiple tables on top of each other in a single table Windows 10 Stack multiple tables on top of each other in a single table Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

Quote:
Originally Posted by Remko View Post
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)
Reply With Quote
  #3  
Old 04-18-2021, 04:18 AM
p45cal's Avatar
p45cal p45cal is offline Stack multiple tables on top of each other in a single table Windows 10 Stack multiple tables on top of each other in a single table Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

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.
Reply With Quote
Reply

Thread Tools
Display Modes


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
Stack multiple tables on top of each other in a single table Copy table cell formatting across multiple cells / tables pakistanray Word Tables 2 10-31-2011 08:07 AM
Stack multiple tables on top of each other in a single table Copying Multiple tables from excel into a single word document dineshtgs Word Tables 1 04-07-2011 01:27 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:45 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft