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...
Hi Jean,
Although I agree with Jan that the best & easiest solution would be to create one combined table and work with this....there are a couple of ways to combine your data.
1) Have you heard of Get & Transform? (previously known as Power Query). You could easily combine all the data.
2) Technically there is a way to combine all the data using formulas but it would involve many steps.
3) You could hire a VBA programmer to create code to combine the data.
Cheers,
Kevin
http://www.myspreadsheetlab.com/blog/