Feb 14 2022 10:44 AM
I was wondering if I need a special addition to my excel in order to merge several spreadsheets ino one.
Feb 14 2022 11:47 PM
Hi @jojo9363
since you use Office 365, you do not need any additions. The functionality you need to use is called Power Query (Get & Transform) and is located in the Data-menue.
But you need to get at least some basic knowledge about Power Query.
If all worksheets have an identical structure, you could alternatively use the consolidate functionality, which is also located in the Data menue.
Feb 15 2022 01:09 AM