The column structure in the other sheets will always be the same. To update my data I will need to be able to simply paste new data into the other sheets. However, in my main sheet, I need to be able to aggregate all the data as well as rearrange it.
Each of these other sheets will have the same structure (same columns). And I cannot change the structure (such as moving or adding columns). I will have one main sheet that summarizes and presents all the data from the other sheets. I want to combine all A2:A10 in every sheet into a new table.
How can I combine multiple tables, in different sheets, into a new one?Įx: There are 26 data sheets in my file, Apple, Ball, Cell, Diary… Zebra. How to combine multiple tables, in different sheets, into a new one? English
0 kommentar(er)
