I have a file created for each month of the year and within each workbook there is a sheet for each day of the month.
In each workbook I have created a power query to append each table in each and give me a summary for the month and this works as required.
I am finding it hard to create a separate workbook which will pull in all 12 queries to allow me to see the year at a glance.
Is it possible to use the queries I created in each workbook to create a combined "12 month" query?
In each workbook I have created a power query to append each table in each and give me a summary for the month and this works as required.
I am finding it hard to create a separate workbook which will pull in all 12 queries to allow me to see the year at a glance.
Is it possible to use the queries I created in each workbook to create a combined "12 month" query?
