Forum Discussion
Looking for help: Combining multiple tables in excel 2016
Hello, I have a workbook with 4 different worksheets (4 different tables). I would like to be able to create an extra worksheets that incorporates all 4 tables into one and that is reactive to change...
Why not copy all four tables to the one sheet and then get rid of the four original sheets? Add a column to the new sheet which contains the name of the tabs the data originally was on.
This is what I also originally thought. If it is the same dataset then it should be all together in one table. If for some business reason the four tables must remain separate then there are ways to dynamically combine them.
