Forum Discussion
MOVE DATA FROM DIFFERENT SHEETS AND TO COMPILE IT IN ONLY ONE TABLE
Hello Everybody I am trying to create an excel file that takes the information of the different sheets (define range) and to put it automatically in a table. The question is that new sheets can be...
ExcelExcitingis correct with Power Query.
Something to be considered for the workbook is why there is a need to keep producing new sheets. Power Query can handle it but why not enter the data into 1 sheet then use Excel's analysis tools (Pivot, subtotal, filters, etc.) to display the data you need? Something to consider.