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.
You can add columns to the blue dynamic table as well. The syntax of the green table won't be harmed. Only the order of the columns could be different in the green table. This can be corrected with simple changes in the Editor.
In the attached file i added columns date, name, place and notice on the right side of the table. Within the Power Query Editor i've arranged the columns accordingly. After each refresh the order of the columns in both tables is the same.
Thank you so much
I applied same steps you've done in the excel file and I managed to create what I wished for.
I appreciate your time and effort.
Thank you
I applied same steps you've done in the excel file and I managed to create what I wished for.
I appreciate your time and effort.
Thank you