Forum Discussion
Copy Power Query result data to a Table object
Hi all, I'm using Excel 365, in a workbook I have : 1. Worksheet in which I have a Power Query running, the PQ is taking a sub-set of data from a different file. At the moment the PQ filter ...
rnnbr Yes and no. I see what your are working on but don't really understand what you need. You have a table that comes out of PQ (the green one) and then you want to include it in the blue one where extra information is added. Perhaps you want to add a column to a PQ generated table and keep this additional information synchronised when you refresh PQ. If so, that's possible if you follow some basic steps. Google for "self referencing table power query" and you'll find many resources that describe the process.
Riny_van_Eekelen for various reasons I need to populate the Table, not only that there is more logic on it but it’s then being used by other worksheets, I’ll try to start uncovering how to loop through the PQ results and copy the data to the Table