Forum Discussion
Automatically Appending Power Queries?
Yes, you will need to use = Excel.CurrentWorkbook()
This will ensure whenever you add a table in current workbook, they will be appended. But yes, you will need to refresh the query (either manually or through a macro)
I have demonstrated this in below Excel workbook where there are 3 tables and 4th range which I haven't converted into table.
When you convert 4th range into table and you refresh the query, the 4th table will also get appended.
Also I have applied filter to remove Result table otherwise Result table will also get appended.
Yes, you will need to use = Excel.CurrentWorkbook()
This will ensure whenever you add a table in current workbook, they will be appended. But yes, you will need to refresh the query (either manually or through a macro)
I have demonstrated this in below Excel workbook where there are 3 tables and 4th range which I haven't converted into table.
When you convert 4th range into table and you refresh the query, the 4th table will also get appended.
Also I have applied filter to remove Result table otherwise Result table will also get appended.
This is exactly what im looking for! is there any way I could have yu explain the steps on how you did it?
Steps are given in the query itself. In Excel - Data - Queries and Connections - Click on the Query to see query steps