|
|
#1
04-17-2021, 08:07 AM
|
|||
|
|||
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? 
|
|
|
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 |
Mac OS X 
Office 2016 for Mac
Threaded Mode