Automatically Appending Power Queries?
Hello! I was hoping to get some help with a worksheet I am working on. Currently, I have about 25 different tables that I have combined into one large power query. Each of these tables is in the ...
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.
