Jan 08 2021 11:10 AM
Howdy All,
How do we get multiple child tables to aggregate into a parent table both cleanly and automatically as child tables are updated?
We remarket equipment for hospitals, so we have several inventory lists. We keep those lists in tables on a tab, one table per tab. A corporate body often oversees hospitals, and individuals at those corporate bodies often wish to analyze all hospitals' data at once. We want to be able to aggregate several tables into one table automatically. It would be helpful to find a way such that as individual hospital inventories are updated, a master list is aggregated. The master list could then be published for use.
THANK YOU!
AndyParker
Jan 08 2021 12:15 PM
Power Query could be the solution if only you have Excel for Windows.
Jan 08 2021 12:19 PM
If you have identical tables, you can merge them into one table easily using consolidate feature in excel.
check these links for tutorials
https://corporatefinanceinstitute.com/resources/excel/study/excel-consolidate/
* If my post helped you, please click on like.