Forum Discussion
Solved
Automatically pull data from excel table to another based on criteria
I'm working on excel table that has currency exchange data for multiple currencies and multiple filters to specify the the operations, I would like to keep the excel table as it is for daily use of d...
I would use Power Query as well. In the attached file you can enter data in the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse. Then select refresh.
The layout in the screenshot is for illustration. The green table can be draged to the right and then thousands of rows can be added to the blue table.
I would use Power Query as well. In the attached file you can enter data in the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse. Then select refresh.
The layout in the screenshot is for illustration. The green table can be draged to the right and then thousands of rows can be added to the blue table.
This is just how I want! Thank you
The blue table is main dynamic table is that right?
and the green table I want in separate sheet, can you please tell me how I can do it?
The blue table is main dynamic table is that right?
and the green table I want in separate sheet, can you please tell me how I can do it?
You are welcome. Yes the blue table is the main dynamic table and the green table is the result table. In the attached file the green table is on another sheet.
- Thank you
Can you tell me the steps to follow up with the way of creating such relation between the two tables?In the worksheet with the green table you can follow the steps shown in the screenshot to start the Power Query Editor.
In the Power Query Editor you can click on any of the applied steps and view the changes of the data.
Some of the applied steps have a gear icon on the right. An example is highlighted in the below screenshot. You can click on the gear icon to view the applied rule.
